=Date(year(A1),month(a1),1)

--
Kind regards,

Niek Otten


"oomyoo" wrote in message
...
Hi,

I would like to have the following:

A1 B1
=TODAY() need formula

Cell should say:
A1 B1
12/20/05 12/1/05

Any ideas?

Thanks in advance :)