Late but an alternative:

=A1-DAY(A1)+1

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"April S." wrote in message
...
I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05