Can excel calc the difference between 2 dates removing weekends?

G

Guest

Does anyone know how to get excel to create the numbers of days difference
between 2 dates and removing the weekends at the same time using a formula?
 
F

Franz Verga

Adam said:
Does anyone know how to get excel to create the numbers of days
difference between 2 dates and removing the weekends at the same time
using a formula?
Click to expand...


Hi Adam,

you can use simply the function NETWORKDAYS:

=NETWORKDAYS(start_date,end_date)

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 

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 calculate the number of days between two dates 2
Diff in business days 2
Template for calculating different number of days between 2 dates 1
Creating and transit time excel formula 4
Difference of time 3
Count days between two dates excluding weekends 1
Calculate Number of Days Between Dates Minus Weekends 3
Calculate number of WEEKENDS between two dates? 3

Top