list of dates by month w/ same date

[dwolf]

Can anyone help me create a list of dates that increase by one month, but have the same date? I tried the following: =DATE(YEAR(G1),MONTH(G1)+1,DAY(G1)). However if my beginning date at G1 was the 31st of the month, then the result for February becomes March 3d.

 

[kpark91]

If it was 31st of January. What should the result be?
It can't be February 31st cuz it d.n.e!!

 

[Jonmo1]

Welcome to the board...

Building on Kparks comments...

Given hat March 3rd is not a desireable result, I would assume you want
Jan 31st to convert to Feb 28th (or 29th on leap year)

Try
=EDATE(G1,1)

This requires the analysis toolpack from Tools - Addins


Hope that helps.

 

[dwolf]

Thanks for the help.

The edate function helped, but did not fix the entire problem. What I am trying to do is to create a list of 60 months with the starting point being a variable. I tried edate,1, but after the first instance of February, all of the dates were the 28th.

 

[kpark91]

I'm not too sure but try

Your Cell=EDATE($G$1, 1)
Your Next Cell = EDATE($G$1, 2)

Then select both cells and copy down.

Again, I am not too sure about this EDATE() function so I think it may do the trick.

 

[dwolf]

Thank you all very much! I have it working now