OpenOffice.org Calc formula to check if day is last day of the month

win32sux · 01-19-2009, 12:09 PM

I've got a CD which does the monthly compounding on the last day of every month instead of every 30 days. The bank gave me a print-out (of course), but I'd like to make my own Calc spreadsheet too. My question is: How do I check whether a certain day is the last day of the month? In other words, I'm looking for something that returns TRUE if it's the last day of the month and FALSE if it isn't. I'm using OpenOffice.org 2.4.1 on Ubuntu 8.10.

win32sux · 01-19-2009, 12:38 PM

I got it. Example:

Code:

IF(EOMONTH(A1;0)=A1;"Yes!";"No!")

Assuming cell A1 contains a date, the cell this formula is used in will display "Yes!" if the date falls on the last day of the given month and "No!" if it doesn't. Thanks to anyone who took the time to read my question!