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

--
Regards
Frank Kabel
Frankfurt, Germany

RONBO wrote:
I need a date formula that will insert the date as the
1st of what ever month it is, i.e. in Feb, no matter what
the date is ,it would return 2/1/2004. In Mar it would
always be 3/1/2004.

Any help is appreciated.