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

A

April S.

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
 
G

Govind

Hi,

Use

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

Change cell A1 accordingly.

Govind.
 
D

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.
 
G

Govind

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

Govind.
 
A

April S.

Thanks! both Govind and Dave. It works perfect.

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

Govind.
Click to expand...
 
Top