How do I select same day of month, 3 mths apart when day 31 of mth

Giganews Newsgroups
Subject: How do I select same day of month, 3 mths apart when day 31 of mth
Posted by:  JohnNZ
Date: Wed, 24 May 2006

I want a table of dates for every 3 months after a starting date (could be
15th, 30th 31st etc). Difficulty when it is for example March  31 . The
formula :
=DATE(YEAR(starting date),MONTH(starting date)+3,DAY(starting date))
provides July 1. The correct date should be June 30.

The above formula works fine with days in the mid-month eg. 15th

I am wanting to avoid using the EOMONTH due to some starting dates are
mid-month. Formula should also deal with February!
Thanks

Replies