LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   OpenOffice.org Calc formula to check if day is last day of the month (http://www.linuxquestions.org/questions/linux-software-2/openoffice-org-calc-formula-to-check-if-day-is-last-day-of-the-month-698381/)

win32sux 01-19-2009 12:09 PM

OpenOffice.org Calc formula to check if day is last day of the month
 
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!


All times are GMT -5. The time now is 03:52 AM.