Channel: MrExcel.com
Category: Howto & Style
Tags: excelexcel tutorialsequence function in excel for datesronakmrexcelpivot table in excel to count weekdays by monthhow to convert excel dates to monthshow to convert excel dates to weekdaysexcel tipsmicrosoft excelbill jelengenerate whole year of dates in excel
Description: Ronak asks: How can I use Excel to find out how many weekedays per month for the whole year? This video shows how to do it using SEQUENCE, TEXT and a quick pivot table in Excel.