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

A

Ashok Natarajan

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
 
D

Dav

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)
 
Top