How do I set a date function for previous monthend?
 

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?

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?

On Thu, 8 Sep 2005 10:12:04 -0700, 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?

=TODAY()-DAY(TODAY())




--ron