How do I put a Month into a cell and have the cells below change

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

Guest

I would like to enter "July" in an unprotected cell and have the cells below
automatically generate August, September, October, etc .
 
Assuming the input cell is B5

=DATE(YEAR(B5),MONTH(B5)+1,DAY(B5))

The input cell (as with others) will need to be formatted as mmm and the
date input as 1/7

Regards.

Bill Ridgeway
Computer Solutions
 
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

HOW TO i HAVE OTHER CELLS GENERATE CONSECTUIVE MONTHS 1
Month function 1
There's got to be a better way 4
Subtract 1, 2 and 3 months from the text "September" 8
Monthly Percent Increase 1
Contiguous cells are blank - Delete 2
Using a #Ref! in a column Sum 3
Count the Number of Weekdays by Month 3

Back
Top