Labeling dates

  • Thread starter Thread starter kim
  • Start date Start date
K

kim

I am looking to have Excel recognize that a date is between a certain
period and put a month label in the next cell. Basically, it would
see in A1 that the date is between January 1 and January 31 and would
put the label "January" in B1. Is there any way to do this so that it
would recognize all of the months? Also, can I make it recognize that
the month is January (or whatever) regardless of the year following
the month and day?

Thanks for any tips.
 
=text(a1,"MMMM")

May work ok.

I am looking to have Excel recognize that a date is between a certain
period and put a month label in the next cell. Basically, it would
see in A1 that the date is between January 1 and January 31 and would
put the label "January" in B1. Is there any way to do this so that it
would recognize all of the months? Also, can I make it recognize that
the month is January (or whatever) regardless of the year following
the month and day?

Thanks for any tips.
Click to expand...
 
Back
Top