NETWORKDAYS

L

Loi

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


=NETWORKDAYS(C4,D4)
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Sumifs with Subtotal 0
NETWORKDAYS 4
Unable to nest my IF statements properly 2
The sum of the same function that is used for a range of cells 2
How do I include names in formula by picking up names from rows 6
formula or macro to change a formula in muliple spreadsheets 1
networkdays alternative 2
NETWORKDAYS 0

Top