I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05

Hi,

Use

=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")

Change cell A1 accordingly.

Govind.

April S. wrote:

I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05

I think I'd drop the =Text() portion:

=date(year(a1),month(a1),1)

And format the way I want.

Then it's still a date.

Govind wrote:

Hi,

Use

=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")

Change cell A1 accordingly.

Govind.

April S. wrote:

I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05

--

Dave Peterson

Ya. thats fine. I just added the Text portion so that the result comes
in the format desired by April.

Govind.

Dave Peterson wrote:
I think I'd drop the =Text() portion:

=date(year(a1),month(a1),1)

And format the way I want.

Then it's still a date.

Govind wrote:

Hi,

Use

=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")

Change cell A1 accordingly.

Govind.

April S. wrote:


I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05

Thanks! both Govind and Dave. It works perfect.

"Govind" wrote:

Ya. thats fine. I just added the Text portion so that the result comes
in the format desired by April.

Govind.

Dave Peterson wrote:
I think I'd drop the =Text() portion:

=date(year(a1),month(a1),1)

And format the way I want.

Then it's still a date.

Govind wrote:

Hi,

Use

=TEXT(DATE(YEAR(A1),MONTH(A1),1),"mm/dd/yy")

Change cell A1 accordingly.

Govind.

April S. wrote:


I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05

Late but an alternative:

=A1-DAY(A1)+1

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"April S." wrote in message
...
I need to calculate the first day of the month for the current month.
ie. 12/06/04 = 12/01/04 or 5/05/05 = 5/01/05