get back to day one based on current date

[oomyoo]

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]

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

--
Kind regards,

Niek Otten


"oomyoo" <oomyoo@discussions.microsoft.com> wrote in message
news:0AB47CC1-7D0A-4F58-BAF9-4BFEA4C043F2@microsoft.com...
> 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
>
>

[Ron Rosenfeld]

On Tue, 20 Dec 2005 10:36:04 -0800, oomyoo <oomyoo@discussions.microsoft.com>
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