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

Excel Vba to change displayed year automatically. 14
Duff Date Text 3
Dynamic border formatting based on dates. Use VBA? 1
Average 10
How to enter date as text 6
date format 2
Excel 2010 autofill dates not correct progression 3
Sum workdays by month from List of Start/End dates 4

Back
Top