WORKING DATES.

O

OSCAR

Guys.
In A1 i have to enter the date of delivery, A2= Today() and in A3 I need to have the number of working days since the date of delivery(No weekends).
Lets say:
A1 B1 C3
03/29/04 04/09/04 10 days

Is this possible?

Thank you.
 
P

Patrick Molloy

=NETWORKDAYS(A1,B2)

NETWORKDAYS() is part of the standard add-ins : The Analysis Toolpak
 
F

Frank Kabel

Hi
have a look at NETWORKDAYS (the Analysis Toolpak has to be installed
for this) and use
=NETWORKDAYS(A1,A2,holiday_list_if_required)
 
Top