Fetching all the monday dates (only) for the past 4 weeks?-CodePudding

Home > Software engineering > Fetching all the monday dates (only) for the past 4 weeks?

Fetching all the monday dates (only) for the past 4 weeks?

Time：03-28

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!

CodePudding user response：

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")

Page link：https//www.codepudding.com/Softwareengineering/351222.html

Prev:How do I print the current date without the dashes?

Next:Query causes UPDATE syntax error, when 'where-attribute' is a date

Tags：

excel

date

Links：
CodePudding