On Tue, 20 Dec 2005 10:36:04 -0800, oomyoo
wrote:

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 :)


B1: =a1-day(a1)+1


--ron