Aug312010

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

tom asks:

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).


Know someone who can answer? Share the question with your friends!

Comments for this Question are closed.

If you are looking for help, please ask a new question here.

We will be happy to help you!

Hide 1 Comment

  • Eamoncollins September 8, 2010

    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)

Please wait...