Forum Discussion
EOMONTH
I am trying to use the formula of EOMONTH but I don't get it to work, please help 👐. I am letting this scree shoot so someone can tell we where I ma wrong.
2 Replies
You don't anything wrong. Format the cell where you enter =EOMONTH(J4, 1) as Date
Lomburus : you may be wondering why Lorenzo can state with such absolute certainty that you didn't do anything wrong. What he didn't explain is how dates work in Excel. Here's an excerpt from Exceljet.net, a helpful website for understanding many aspects of Excel.
"In Excel's date system, dates are serial numbers beginning on January 1, 1900. January 1, 1900 is 1, January 2, 1900 is 2, and so on. More recent dates are much larger numbers. For example, January 1, 1999 is 36161, and January 1, 2010 is 40179."
It's this underlying feature that makes date math possible, which is the why behind the way Excel stores dates.
