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

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

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

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 V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Galen" (gro=org) wrote in message
...
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.
--
Galen

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

Re-reading OP's message, I think we need =WORKDAY(A1,2)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
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 V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Galen" (gro=org) wrote in message
...
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.
--
Galen

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

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.

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

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.