The month function in excel should suffice
Its just month(the date you are interested in)
so if the date wa in cell d4 =month(d4)
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=503939