Another alternative to EOMONTH: =today()-day(today())+1
(or, to operate on a date given in A1, =a1-day(a1)+1. )


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