Previous Month End

[Tristan]

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?

 

[Don Guillett]

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

 

[Tristan]

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]

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

 

[Bob Phillips]

=TODAY()-DAY(TODAY())

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Gord Dibben]

Tristan

Perhaps this formula?

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

Returns August 31, 2006


Gord Dibben MS Excel MVP

 

[Tristan]

Solution received in multiple posts. Thanks to all for the assistance.

 

[Don Guillett]

Bob's the best