I am trying to calculate the number of weekend days (Sat + Sun) in a range given 2 dates, each in their own cell. I have just about lost my mind, there seems to be endless ways of calculating workdays, but weekends are eluding me. PLEASE help!
I am trying to calculate the number of weekend days (Sat + Sun) in a range given 2 dates, each in their own cell. I have just about lost my mind, there seems to be endless ways of calculating workdays, but weekends are eluding me. PLEASE help!
=(A2-A1+1)-NETWORKDAYS(A1,A2) where a1=start date and a2 = end date
Simply subtracts the workdays from the total leaving the number of weekend days. This formula is inclusive of all days from start to end. In other words- 1 Jul 12 to 31 Jul 12 would be 31 days. If you don't want it inclusive, then remove the +1.
(OOOPS....corrected)
In Excel 2010 you can use NETWORKDAYS.INTL function; it can be customised to count any day or combination of days, e.g. to count Saturdays and Sundays try
=NETWORKDAYS.INTL(A2,B2,"1111100")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks