Calculate dates between 2 dates

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

Hello How do I calculate the number of business days between 2 days,
example how many business days are there between 1-9-08 and 1-3-08 thanks
 
You can use the =NETWORKDAYS(A3,A4) function. You must attach the Analysis
ToolPak add-in to use this function. Tools, Add-Ins.

This function assumes workdays are M-F. If you also need to exclude other
days (holidays) there is a 3rd arguments.
 

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

Calculate date difference exclude Wkend 4
Count days without weekends 2
Expanding Date formula 1
Date Value Error 6
calculate number of days 7
Sumproduct count between dates for specific day 7
Calculating every work day between two dates 3
Calculating time between mulitple dates 4

Back
Top