Thread
:
Reverting to a date
View Single Post
#
2
Posted to microsoft.public.excel.programming
JWolf
external usenet poster
Posts: 136
Reverting to a date
=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.
Reply With Quote
JWolf
View Public Profile
Find all posts by JWolf