Date Formula Excluding Weekends
 

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.

Date Formula Excluding Weekends
 

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.

Date Formula Excluding Weekends
 

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


Replace @mailinator.com with @tiscali.co.uk


"Dvinechild" wrote in message
...
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.

Date Formula Excluding Weekends
 

This works beautifully, thanks for the note.

"FinRazel" wrote:

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.