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?