Wonderful! Thanks!

Lila

"Bob Phillips" wrote in message
...
=TODAY()-DAY(TODAY())+1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lila" wrote in message
...
I would like a cell to show the first day of the current month. For
example, today is Monday, February, 27, 2006. I would like the cell to
show
Feb 1, 2006.

I tried

=month(now())

but it showed Jan 01, 1900.

I tried putting the =now() in one cell and then using =month(a1) where
a1
referenced the cell with the now function with the same result as above.

Any suggestions?

Lila