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.

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.

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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"Dvinechild" <(E-Mail Removed)> wrote in message
news:EF01CA6E-7822-45B0-B2B1-(E-Mail Removed)...
> 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.
>

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.