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