Apple Numbers: Check for End of Month
Is there a formula to check to see if a given date is in fact the end of the month?
What would that check look like?
Question marked as
One way would be to use the EOMONTH function, something like this:
= to call up the formula editor and enter: A2=EOMONTH(A2,0)
If the values on the two sides of the = within the formula are the same then Numbers returns a TRUE.
Use ; instead of , in the formula if your region uses , as a decimal separator.
You can read more about the EOMONTH function by going to Help > Formulas and Functions Help in your menu.
SG