Calculating difference between two dates without considering Saturdays & Sundays

  • Thread starter Thread starter NC
  • Start date Start date
N

NC

Hi all,

I want to calculate the diffrence between two dates but Saturdays &
Sundays Should be ommitted while calculating this difference.

e.g. Diffrence bet 1st & 22nd Nov. Should come as 15, ommitting the
saturday & Sunday inbetween. & not 21 as is given by DateDif function.

can any one please help me on this.Maybe someone would have a ready UDF
for that.If yes, then please send me the VB code for that
Thanks & Regards
NC
 
Hi NC!

You can use the function NETWORKDAYS to calculate the days between two
dates, without saturdays and sundays.
If the first date is in A1 and the last date is in A2, the formulas should
looke like this: =NETWORKDAYS(A1,A2)


Best regards

Stefan Hägglund
Microsoft
 
Note that to use NETWORKDAYS you have to load the Analysis Toolpak
Add-in (Tools/Add-ins... check the appropriate checkbox).
 
Back
Top