And what do you want as the date result? The first of the month? the end of
the month? The current year? or some other year?

Regards,
Fred.

"Esra" wrote in message
...
The month in cell a1 says January, or Febuary, or March,,,,,,



On Mon, 31 Mar 2008 23:22:27 -0400, "T. Valko"
wrote:

the dates of the month in cell a1?

How is the month entered in the cell?

As the month name as a TEXT entry: January or Jan

As a true Excel date: 1/1/2008

As the number of the month: 1

???