WORKING DATES.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=NETWORKDAYS(A1,B2)

NETWORKDAYS() is part of the standard add-ins : The Analysis Toolpak
 
Hi
have a look at NETWORKDAYS (the Analysis Toolpak has to be installed
for this) and use
=NETWORKDAYS(A1,A2,holiday_list_if_required)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add to a "number as text" 10
Find then highlight in yellow 6
Help with dates 5
Monthly Report 2
Minus Dates 5
Access Count dates within a Month 4
time_report_date-wise_employee-wise 6
separating date and time 5

Back
Top