get back to day one based on current date

oomyoo · Dec 20, 2005

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

Niek Otten · Dec 20, 2005

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

Ron Rosenfeld · Dec 20, 2005

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