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