Business Days Only

[Guest]

Does anyone know how to skip the weekends in date calculations? For example column "A" is a defined as an Open Date and column "B" is a Target Date.

What I am looking for:

A1=11/21/2003 (a Friday
B1=A1 + 1 (where the result will show 11/24/2003 [a monday]

What I will not know is what the value of column "A" (the Open Date) will be at any given time.

 

[Dave R.]

workday(a1,1)

Does anyone know how to skip the weekends in date calculations? For

example column "A" is a defined as an Open Date and column "B" is a Target
Date.

What I am looking for:

A1=11/21/2003 (a Friday)
B1=A1 + 1 (where the result will show 11/24/2003 [a monday])

What I will not know is what the value of column "A" (the Open Date) will

be at any given time.

 

[Vasant Nanavati]

Try:

=WORKDAY(A1,1)

will give you the next working day after the date in A1. You can also allow
for holidays; see help on this function . You need to have the Analysis
Toolpak add-in installed to use it.

--

Vasant

Does anyone know how to skip the weekends in date calculations? For

example column "A" is a defined as an Open Date and column "B" is a Target
Date.

What I am looking for:

A1=11/21/2003 (a Friday)
B1=A1 + 1 (where the result will show 11/24/2003 [a monday])

What I will not know is what the value of column "A" (the Open Date) will

be at any given time.

 

[Kate]

-Type 11/21/03 in A1
-Type 11/22/03 in A2
-Highlight both A1 and A2
-Click on the little box on the right hand side of the
highlighted area and drag down
-Type FRIDAY in B1
-Type SATURDAY in B2
-Click on the little box on the right hand side of the
highlighted area and drag down. It will automatically
prefill the correct days
-At this point you can do a sort and take out all the
Saturdays and Sundays
*I'm sure there is an easier way to do this, but this
method has always worked for me

Kate

-----Original Message-----
Does anyone know how to skip the weekends in date

calculations? For example column "A" is a defined as an
Open Date and column "B" is a Target Date.

What I am looking for:

A1=11/21/2003 (a Friday)
B1=A1 + 1 (where the result will show 11/24/2003 [a monday])

What I will not know is what the value of column "A" (the

Open Date) will be at any given time.

 

[Guest]

Thank You. I had to make the Add-In "Analysis ToolPak" available, but it works like a charm

----- Dave R. wrote: ----

workday(a1,1

Does anyone know how to skip the weekends in date calculations? Fo

example column "A" is a defined as an Open Date and column "B" is a Targe
Date

What I am looking for
A1=11/21/2003 (a Friday

B1=A1 + 1 (where the result will show 11/24/2003 [a monday]

What I will not know is what the value of column "A" (the Open Date) wil

be at any given time