'Fetching all the monday dates (only) for the past 4 weeks?
I'm working on an excel report where I need the dates of the past 4 Mondays from the current dates. so for example, today's march 28th, I need to get the 4 dates Feb 28, March 7,14, 21.
Is there any way for me to do this formula on excel? Thank you!
Solution 1:[1]
With Excel-365 you may try-
=TEXT(FILTER(SEQUENCE(28,1,TODAY()-1,-1),TEXT(SEQUENCE(28,1,TODAY()-1,-1),"dddd")="Monday"),"dd-mmm-yyyy")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Harun24hr |