ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   NETWORKDAYS (https://www.excelbanter.com/new-users-excel/4882-networkdays.html)

Loi

NETWORKDAYS
 


Hi,
Please tell me what is the formula below. What is
NETWORKDAYS mean?
Thank you
Loi


=NETWORKDAYS(C4,D4)


Chip Pearson

Loi,

NETWORKDAYS means Net Workdays (not Network Days), and returns
the number of weekdays (Monday through Friday) between two dates,
excluding weekends (Saturday and Sunday) and optionally holidays.

Your formula return the number of weekdays between the dates in
cells C4 and D4.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Loi" wrote in message
...


Hi,
Please tell me what is the formula below. What is
NETWORKDAYS mean?
Thank you
Loi


=NETWORKDAYS(C4,D4)





All times are GMT +1. The time now is 06:11 PM.

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