How do i count number of weekdays between two dates?
|
Hi
check out the NETWORKDAYS function syntax: NETWORKDAYS(start_date,end_date,holidays) this counts the number of days between the start date & end date, excluding any weekends and any holidays you enter. This function needs the Analysis Tool-Pak installed. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Sanjay Shah" wrote in message ... |
All times are GMT +1. The time now is 05:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com