Add months

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
A

Arvi Laanemets

Hi

=DATE(YEAR(Sheet1!A1),MONTH(Sheet1!A1)+N,1)
returns 1st day of Nth month relatively to date in Sheet1!A1
 
With the Analysis Toolpak loaded (Tools>Addins):
=EOMONTH(Cell,0)+1
Where Cell is a date in the current month.
 
Each year I create a calendar (which is all formulas and works really
slick), but the question I have deals with the month at the top of the page.

The calendar is 12 sheets, one for each month. At the top is the name of
the month and year which produces the days in the correct position in each
day. What I'd like to do is enter only the month and year on the first
calendar, then the following sheets automatically correct for the year.

I think I'm doing it the wrong way .. I was referencing the cell on the
prior sheet and adding 30 days. Is there a better method?

Thanks!

Annette
 
Use

=DATE(YEAR(Sheet1!A1),MONTH(Sheet1!B1)+1,1)

where A1 holds the year and B1 the month,will return the next month's first
day
 
Back
Top