Forum Discussion
Solved
Getting the date of each mondays between two dates
Hi I am using google Sheets and I need a formula or function that returns the date of each Monday between two dates, see the attached file. Thx.
Format column C as date.
In C6:
=SEQUENCE(ROUNDUP((J7-J6)/7,0),1,J6+7-WEEKDAY(J6,12),7)
This will automatically spill to the rows below.
Try this:
=LET(s,SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)),FILTER(s,(WEEKDAY(s)=1)+(WEEKDAY(s)=3)+(WEEKDAY(s)=4)+(WEEKDAY(s)=5)))
I tested in Excel. Does that work in Google Sheets?
i will test it on google sheet
I need Monday included in this formula. How?
I need Monday included in this formula. How?