Last day of last month
 

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

Last day of last month
 

Try this...

A1 = 9/20/2009

=A1-DAY(A1)

--
Biff
Microsoft Excel MVP


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

Last day of last month
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

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

Last day of last month
 

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)

Last day of last month
 

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

"Jim" wrote:

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

Last day of last month
 

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





Longaberger_lover wrote:

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

"Jim" wrote:

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

--

Dave Peterson