Try one of these:

=EOMONTH(TODAY(),-1)+1

Note: If the EOMONTH function is not available, and returns the #NAME?
error, install and load the Analysis ToolPak add-in

OR

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.