Final day of month

[Guest]

Am trying to allow someone to set a bill day of 30 or 31, and then create a
calendar that changes this to the last day of the respective month. EOMONTH
does not work.

 

[Guest]

Am trying to allow someone to set a bill day of 30 or 31, and then create a
calendar that changes this to the last day of the respective month. EOMONTH
does not work.

Always best to be specific about HOW something doesn't work. Did Excel
return an error value or the wrong result? If it returned the error value
#NAME?, then the most likely reason is that you haven't enabled the Analysis
ToolPak add-in. It's NOT enabled by default. See online help for the EOMONTH
function for directions on what you'd need to do. In future, you may find it
quicker to check online help first.

 

[Peo Sjoblom]

Last day of what month, do you mean if you have a date in A1 like 05/10/07
then you want to add 30 days and then get the last date of the months? if
the date was 05/10/07 it would be 06/30/07?

=DATE(YEAR(A1+30),MONTH(A1+30)+1,0)

I am sure EOMONT is working if you have ATP installed

=EOMONTH(A1+30,0)

 

[Roger Govier]

Hi

Without using the Analysis Toolpak function EOMONTH, you could use
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)

to always give the last day of the current month.