First and Last Working Days of the Month Excel
First and Last working days of the month Excel - In this video, i demonstrate a formula approach to getting the first and last days of the month. The spice here is using array literals/contrast, taking advantage of pattern recognition.
Workbook link:
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:57 First working day (Month)
02:12 Last working day (Month)
03:34 Both results dynamically
04:16 Using Array Literals
07:28 First working day for a 12-month period
08:17 Last working day for a 12-month period
09:13 Spilling a multicolumn array for first/last working days
11:32 closing thoughts