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.

--
Regards
Roger Govier



"B" wrote in message
...
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.