Count Day of Week Between Dates in Excel (How many Fridays?)

Count Day of Week Between Dates in Excel (How many Fridays?)

 

 

Find out how you can quickly count the number of Fridays between two dates in Excel. You can use this technique to also count the number of weekends, Mondays, Tuesdays or any day of the week between two dates.  

 

The Excel formula is simple: It uses networkdays.intl function to get the answer. The difference between NetWorkDays function and the Networkdays.Intl function is that you can choose which days you'd like excluded. Excel Networkdays automatically excludes Saturdays and Sundays.

 

Related Topics:

• Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT and SUM 
• Master Excel's SUMPRODUCT Formula 
• Excel SUM based on Partial Text Match (SUMIFS with wildcards) 
• Excel Sum(ifs) between dates, sum month and sum with multiple criteria