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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count specific days in between dates 2
Specific Date from a Range 3
Calculating the number of months 2
COUNT BETWEEN A SPECIFIC DATE RANGE 4
How do I convert dates to months in Pivot Tables? 1
Grouping Dates by Month 4
Excel Formula Help! 2
Interesting problem in excel, producing a list for aspecific date 3

Back
Top