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


"Dana DeLouis" wrote:

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 wrote:
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.