Find in-between dates from start date to end date

1

Hi, I feel stuck… I cannot figure out how to find the dates in-between a starting and ending date.

I have the starting date of Today() and an ending date of Today()+180. I want to find the same day of the week as Today(), and only get those in-between dates.

I feel like this formula should work, but it just doesn’t.

Sequence(Today(), Today() +180, by: 7)

Any help would be super appreciated!

2

hi @Micah_Lucero ,
it works , you are maybe confused by the outcome (number) and you’d rater see a date like below:

Sequence(Today(), Today() +180, by: 7).ForEach(CurrentValue.FormatDateTime(10,0))

cheers!
Christiaan

2 Likes
3

You’re a hero! Thank you!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.