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

Similar Threads

How to use/create code in MS Word to calculate age? 0
How do you calculate number of workdays from dates entered? 0
How to calculate the number of Workdays for irregular work pattern 1
Calculate workdays for irregular work patterns 1
Calculating number of workdays between 2 dates 15
how do i create a formula to give a workday date? 2
Formula Workdays-Holidays-adjustments 4
determine workdays 1

Top