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 |
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