Try this:
if your starting date, 04/01/08, is entered in D1, enter the following
formula in D2
=IF(WEEKDAY(D1+1,2)<6,D1+1,IF(WEEKDAY(D1+1,2)=6,D1 +3,""))

And then fill down
--
Anne Murray


"Dvinechild" wrote:

Hello gang,
Looking for guidance on a desired formula that would reflect the following:

Objective:
Give consectuive dates per quarter(s) in column minus weekends.
i.e. = Tues, Apr 01
Wed, Apr 02 (or desired date format)

Parameters:
04/01/08 - 06/30/08

Result:
Should only reflect work week days (holidays are okay to include) but skip
weekends when drag/drop through the column.

Can't seem to come up with an equation to get this to work right.