Excel and DATEDIF help

  Durko 13:34 24 Nov 2008

When using the DATEDIF function in Excel to calculate the number of Days or Months between dates, is there a function to omit it including Saturday and Sundays in order to only generate results for just Monday to Fridays. Seen something about using Networkdays but unsure if that's the route to folow.

Any advice much appreciated.


  VoG II 13:42 24 Nov 2008



where A1 houses the first date.

If you want to exclude holidays as well


where holidays is a range containing the holidays.

  Durko 13:56 24 Nov 2008

That's great just what I needed.

Thanks again VOG.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?