Excel and DATEDIF help

  Durko 13:34 24 Nov 2008
Locked

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.

Durko

  VoG II 13:42 24 Nov 2008

Try

=NETWORKDAYS(A1,B1)

where A1 houses the first date.

If you want to exclude holidays as well

=NETWORKDAYS(A1,B1,holidays)

where holidays is a range containing the holidays.

  Durko 13:56 24 Nov 2008

That's great just what I needed.

Thanks again VOG.

Durko

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 ?