Formula for Serial Date n+2 +2 +3 +2 +2 +3...

[Galen]

Hi,

I woulld like to enter a date in the first cell of a row and have the
formula calculate and enter the remaining dates up through a designated cell
in the sam row. The dates to be entered will represent Mon - Wed - Fri, Mon
- Wed - Fri, etc. For example, the results of the formula will be:

5-Jan, 7-Jan, 9-Jan, 12-Jan, 14-Jan, 16-Jan, 19-Jan, etc.

Thank you for your interest in this request.

 

[Bernard Liengme]

With the starting date in A1:
In B1 enter =WORKDAY(A1,1); this will return a number like 39785; so format
it to show your preferred date format
Copy B1 across the row as needed
You may wish to read Help to see how WORKDAY can also 'jump holidays as well
as weekends.
best wishes

 

[Bernard Liengme]

Re-reading OP's message, I think we need =WORKDAY(A1,2)

 

[Dana DeLouis]

Hi. If A1 is Mon, Wed, or Fri,
Then one way to get a 2-2-3 Sequence is:

=A1+MOD(17,WEEKDAY(A1)+1)

And copy down(or across)

- - -
HTH
Dana DeLouis

 

[Galen]

Dana (et Bernard),

Thank you for the formula(s)!

Bernard, yours just missed.

Dana, yours hit it!

(I apologize for the late reply. For the past week, the Excel program was
acting up to the point where it would not even calculate previously
functioning formulas in existing worksheets -- I couldn't test your formulas.
Excel, at least through the 2003 version, continues to have problems playing
nice with others.)