Labeling dates

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.
 
D

Dave Peterson

=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...
 
Top