Counting Days of The Week Only In a Formula

B

Bruno

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
 
J

JE McGimpsey

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