Using CASE Statement to Derive Months from Numeric Dates

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

Guest

Hello,
I have a list of hire dates that I need to group by month. I've included in
the macro to convert the dates from text > column using the "\" as a
delimiter (ex: 1\1\2007 would be split into three columns...the month column
now houses a 1, the day column houses a 1, and the year column houses a
2007). I then want a case statement in the macro that will change all the
months in the month column that begin with a 1 to January, a 2 to February,
and so on. The month column is currently my column D, and I plan on deleting
the day and year columns as they are not needed...I just need hire dates
grouped by the month that the hire occurred in.
 
If your date is in A1, this formula returns the month:

=TEXT(A1,"mmmm")

- Jon
 
You must log in or register to reply here.

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

please help me format this date to Month and Year 4
Excel Help with dates 2
How to count # of dates that fall between a start and end date. 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Lousy routine to get the first available day of the month 2
Sum work hours to hours & nearest 10th of an hour 14
Advanced filter on last months results 6
Excel Vba to change displayed year automatically. 14

Back
Top