Tristan

Perhaps this formula?

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1

Returns August 31, 2006


Gord Dibben MS Excel MVP


On Fri, 8 Sep 2006 14:12:04 -0700, Tristan
wrote:

I think I need the formula to consider the current month and input the
previous month end. Example: Today is September 8, 2006, and I need the
formula to input August 31, 2006

"Don Guillett" wrote:

One way to get the end of Sep
=DATE(2006,10,1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
I upload information for the previous month end. I currently use only the
Month and Year, so =TODAY()-10 works. However, I would like to insert the
month, day, and year (Ex: August 31, 2006). Is there a way to do this?