Changing today's date to the first of the month
On Thu, 22 Dec 2005 05:43:03 -0800, "Scott"
wrote:
Is there a function in Excel to change a date to the first of the month,
ie. =FIRSTDAY(Now()) to change 12/22/2005 to 12/1/2005
thanks.
=TODAY()-DAY(TODAY()) +1
--ron
|