How can I use Excel to create arbitrary target dates based on a start date?

tom August 31, 2010
Ads by Google

I’d like to be able to use Excel to schedule a quarterly target date, based on an arbitrary start date. The target date should be within 120 days from the start date, fall on a different day of the week, different week (if possible), and different month (not the first month of the quarter again). Basically a target date or dates that are totally unique from the arbitrary start date.

To reiterate, it must be unique with regards to day of the week, month of the quarter (1st through 4th), week of the month (1st through last), and actual date (1st through 31st).

  1. Eamoncollins
    September 8, 2010 at 3:43 pm

    Assuming your start date is in cell A2 this formula will work (assuming I have followed your instructions correctly). =DATE(YEAR(A2),MONTH(A2)+2,DAY(A2)+8)