WORKING DATES.
 

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.

WORKING DATES.
 

=NETWORKDAYS(A1,B2)

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

--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
"OSCAR" wrote in message
...
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.

WORKING DATES.
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


OSCAR wrote:
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.