ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i count number of weekdays between two dates? (https://www.excelbanter.com/excel-worksheet-functions/20472-how-do-i-count-number-weekdays-between-two-dates.html)

Sanjay Shah

How do i count number of weekdays between two dates?
 


JulieD

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