Forum Discussion
ajl_ahmed
Nov 22, 2022Iron Contributor
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.
- Nov 22, 2022
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.
ajl_ahmed
Nov 22, 2022Iron Contributor
a little bit of modification on my question
If I want to get the dates of each Sunday, Tuesday, Wednesday, and Thursday between the starting and ending dates. What should be the formula?
If I want to get the dates of each Sunday, Tuesday, Wednesday, and Thursday between the starting and ending dates. What should be the formula?
ajl_ahmed
Nov 22, 2022Iron Contributor
Not working on google sheet
- HansVogelaarNov 22, 2022MVP
=FILTER(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)),(WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))=1)+(WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))=2)+(WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))=3)+(WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))=4)+(WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))=5))
or shorter
=FILTER(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)),WEEKDAY(SEQUENCE(J7-J6+1,1,J6+7-WEEKDAY(J6,12)))<6)