Calculate difference between dates

Good morning paula vasile

...and welcome to the forum!!

Originally Posted by paula vasile

Hi, anyone how do I calculate the number of working days between two dates in Excel?

Use the NetworkDays function - it's available using the Analysis ToolPak. Go to Tools > Add-Ins, tick the Analysis ToolPak box and click OK.

Then say you have two dates in A1 and A2 you would use this formula :
=NETWORKDAYS(A1,A2)

You can find an article here about the networkdays function and its limitations and how you can workaround them.

HTH

DominicB