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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique