How do you calculate number of workdays from dates entered?

T

tfleck

I've got this form at work where the user wants to be able to enter dates
into certain cells and write a formula that will calculate how many workdays
are between each date enter. We're talking the standard work week of 5 days.

Also, how about holidays?
 
N

Niek Otten

Take a look at the NETWORKDAYS() function. Look in HELP for details.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Top