Calculate the first day of the month for the current month?

[Guest]

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

 

[Govind]

Hi,

Use

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

Change cell A1 accordingly.

Govind.

 

[Dave Peterson]

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]

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

Govind.

 

[Guest]

Thanks! both Govind and Dave. It works perfect.

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

Govind.

 

[Sandy Mann]

Late but an alternative:

=A1-DAY(A1)+1

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk