How do I set a date function for previous monthend?

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

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

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

[Ron Rosenfeld]

On Thu, 8 Sep 2005 10:12:04 -0700, JDP289 <JDP289@discussions.microsoft.com>
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