ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculate the number of workdays between 2 dates (https://www.excelbanter.com/excel-worksheet-functions/5693-calculate-number-workdays-between-2-dates.html)

Tegid77

Calculate the number of workdays between 2 dates
 

I am trying to figure how many workdays between 2 dates and wondering
what the best way of doing this would be any advice would be greatly
appreciated


--
Tegid77
------------------------------------------------------------------------
Tegid77's Profile: http://www.excelforum.com/member.php...o&userid=16087
View this thread: http://www.excelforum.com/showthread...hreadid=275376


Dave R.

Try =NETWORKDAYS(A1,A2) with the earlier date in A1 and later date in A2.

"Tegid77" wrote in message
...

I am trying to figure how many workdays between 2 dates and wondering
what the best way of doing this would be any advice would be greatly
appreciated


--
Tegid77
------------------------------------------------------------------------
Tegid77's Profile:

http://www.excelforum.com/member.php...o&userid=16087
View this thread: http://www.excelforum.com/showthread...hreadid=275376





All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com