Counting Days of The Week Only In a Formula
 

Hi:

I was hoping that someone could tell me if possible to add only week days to
a formular.

By this i mean for example;

cell A1 (Start date (Thursday)) has 1-Jan
cell A2 (number of working days) has 10
cell A3 (End date) should be 14-Jan not 11-Jan


Thanks in advance

Regards:
Bruno

Counting Days of The Week Only In a Formula
 

Take a look at the WORKDAY() function in Help (it's an Analysis Toolpak
Add-in - choose Tools/Add-ins).


In article ,
"Bruno" wrote:

I was hoping that someone could tell me if possible to add only week days to
a formular.

By this i mean for example;

cell A1 (Start date (Thursday)) has 1-Jan
cell A2 (number of working days) has 10
cell A3 (End date) should be 14-Jan not 11-Jan

Counting Days of The Week Only In a Formula
 

Hi
=WORKDAY(A1,A2)
in A3

--
Regards
Frank Kabel
Frankfurt, Germany


Bruno wrote:
Hi:

I was hoping that someone could tell me if possible to add only week
days to a formular.

By this i mean for example;

cell A1 (Start date (Thursday)) has 1-Jan
cell A2 (number of working days) has 10
cell A3 (End date) should be 14-Jan not 11-Jan


Thanks in advance

Regards:
Bruno