Weekdays between two dates in Excel?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Two solutions found online, two problems.

1) =NETWORKDAYS function should do the job, but I keep winding up with a
#NAME? error. (Using Excel 2003)

2) Formula suggestion, where A2 contains the earlier date and B2 contains
the later date:
=MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5
gets hosed when one or both days are Saturday or Sunday
http://www.ozgrid.com/forum/showthread.php?t=65032

An explanation for 1), modification of 2) or other suggestion is
appreciated. TIA.
 
--Using =NETWORKDAYS(). Incase this formula returns an error you need to
install ATP. To install; from menu Tools>AddIns> check 'Analysis ToolPak' and
hit OK.

=NETWORKDAYS(A1,B1)


--With startdate in A1 and end date in B1

=SUMPRODUCT(INT((B1-A1+WEEKDAY(A1-{2,3,4,5,6}))/7))


If this post helps click Yes
 
Back
Top