In Excel How do I return the Month for a specific date
 

My problem is as follows. My sheet consists of a a range of dates. I need to
assign a date to the specific month like 01-04-2005 would be assigned as
April or 01-11-2005 would be assigned as November.
Alternatively in a Pivot Report can I group a range of dates for a specific
month and then get the result.
Thanks

In Excel How do I return the Month for a specific date
 

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