Try:

=EOMONTH(TODAY(),-1)

This function is part of the Analysis ToolPak add-in. If you do not click
Tools, and then click Add-ins to install and enable the Analysis ToolPak
add-in, the formula will return a #VALUE error. You will also receive a
#VALUE error if either of the function arguments is nonnumeric.

"JDP289" wrote:

I know you can create a =NOW() function to give a date stamp to a file. Is it
also possible to have excel return the previous monthend date?