I am looking for a formula that will use todays date and
revert the cell date to the 1st of last month. i.e.
6/7/2004 would = 5/1/2004.

Thanks for any help.

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

Ronbo wrote:

I am looking for a formula that will use todays date and
revert the cell date to the 1st of last month. i.e.
6/7/2004 would = 5/1/2004.

Thanks for any help.

On Mon, 7 Jun 2004 09:59:00 -0700, "Ronbo"
wrote:

I am looking for a formula that will use todays date and
revert the cell date to the 1st of last month. i.e.
6/7/2004 would = 5/1/2004.

Thanks for any help.

With a Date in A6,
=A6-DAY(A6)-DAY(A6-DAY(A6))+1

or for today:

=TODAY()-DAY(TODAY())-DAY(TODAY()-DAY(TODAY()))+1


--ron