Add months

[Arvi Laanemets]

Hi

=DATE(YEAR(Sheet1!A1),MONTH(Sheet1!A1)+N,1)
returns 1st day of Nth month relatively to date in Sheet1!A1

 

[Jim]

With the Analysis Toolpak loaded (Tools>Addins):
=EOMONTH(Cell,0)+1
Where Cell is a date in the current month.

 

[Annette]

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

 

[Peo Sjoblom]

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