Microsoft Office

Negative Time Values In Excel

I was trying to set up a simple time sheet in Excel. I know that ready-made ones exist, but it’s more fun and educating to make your own, right? And I came across a nasty problem: Excel doesn’t like to display negative time: Turns out there’s a simple solution for this: Enable the 1904 dating […]

Excel Formula to get Number of Days in a Month

It seems Excel still can’t tell me the days in a particular month. The following formula works, though: =DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) Obviously, A1 has to have a date in it. Works like a charm:   Update, much, much later: Looks like LibreOffice has a DAYSINMONTH function.