=date(year(today()),month(today()),1)-1

--
Don Guillett
SalesAid Software

"Tristan" wrote in message
...
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?