PERFECT, exactly what I wanted. Thank you so much.

Esra




On Tue, 1 Apr 2008 00:45:07 -0400, "T. Valko"
wrote:

Try this:

A1 = month name as a TEXT entry: February

Enter this formula in A2:

=IF(A1="",TODAY()-DAY(NOW())+1,--("1-"&A1))

Format as DATE

Enter this formula in A3 and copy down to A32:

=IF(MONTH(A$2+ROWS(A$3:A3))=MONTH(A$2),A$2+ROWS(A $3:A3),"")

Format as DATE

These formulas will return the dates for the month entered in A1 of the
*current year*.