Prev: Adding an apostrophe to a column of numbers
Next: Excel Conditional Formatting for Percentagrs
From: Longaberger_lover on 12 Mar 2010 11:23
=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
From: Dave Peterson on 12 Mar 2010 13:24
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
 | 
Pages: 1
Prev: Adding an apostrophe to a column of numbers
Next: Excel Conditional Formatting for Percentagrs