I have a Numbers sheet that I use to forecast the monthly interest payments on my mortgage and it's working well. The only issue is that the date cells auto-sets to the first day of the month.

Is there any way that I can make a cell automatically set to the last day in the month?

3 Answers 3


Might EOMONTH work for you?

The EOMONTH function returns a date that is the last day of the month some number of months before or after a given date.

Example: =EOMONTH("2/01/2015", 0) returns: Feb 28, 2015


Let us say the current date is in cell A192 and is 21 January 2017. You can insert the eomonth date in another cell with


I know this is old but the answer to have a single field always show the last day of the month for me is


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .