Excel and DATEDIF help

  Durko 13:34 24 Nov 08
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 08

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 08

That's great just what I needed.

Thanks again VOG.

Durko

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced