How do I set a date function for previous monthend?

J

JDP289

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?
 
D

David Hepner

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.
 
R

Ron Rosenfeld

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?
Click to expand...

=TODAY()-DAY(TODAY())




--ron
 
Top