Can excel calc the difference between 2 dates removing weekends?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top