First and Last days of the month Excel - Formulas and array literals
First and Last 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, taking advantage of pattern rceogntion.
Workbook link:https://docs.google.com/spreadsheets/...
00:00 Introduction
00:24 First day of the Month
01:20 Last day of the month
02:04 Dynamic formula to get both first and last days
02:44 Dynamic formula-array literals
04:18 First and Last days of 12 months from the reference date
08:20 Final Thoughts