Date Formula Excluding Weekends

[Dvinechild]

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.

 

[FinRazel]

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

 

[Sandy Mann]

You could use the WORKDAY() function from the ATP addin or if you don't want
to install that try:

=A1+1+(WEEKDAY(A1+1,2)>5)*2

with your start date in A1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dvinechild]

This works beautifully, thanks for the note.

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