Last day of last month

[Jim]

Hello,

In cell A1 I will have the due date of a bill. For this example let's call
it 9/20/2009. Can you help me with a formula that will give me the last day
of the previous month, in this case August 31, 2009.

Thanks for the help
Jim

 

[T. Valko]

Try this...

A1 = 9/20/2009

=A1-DAY(A1)

 

[Jacob Skaria]

Try
=DATE(YEAR(A1),MONTH(A1),0)

If this post helps click Yes

 

[MyVeryOwnSelf]

In cell A1 I will have the due date of a bill. For this example let's

call it 9/20/2009. Can you help me with a formula that will give me
the last day of the previous month, in this case August 31, 2009.

Here's one way in Excel 2003:
=EOMONTH(A1,-1)

 

[Longaberger_lover]

=DATE(YEAR(TODAY()),MONTH(TODAY()),0)
works on Excel 2003 if you don't want to reference another cell w/ a date.

 

[Dave Peterson]

Another one:
=today()-day(today())
(format as a date)