Return Date of Friday of "This Week"

1

Hello!

We have a recurring meeting every Friday, and I am simply looking for a formula to automate the date in a line of text for a view of what’s happening this week Friday so they know what agenda they’re looking at.

Example, visiting the page any day between March 13 - March 19 should return " 3/18/22."

Is that possible?

2

For sure! There are a lot of ways to handle use-cases like this, and different formulas you can write to extract that data - but here’s one that comes top of mind for me:

image
image1188×260 40.2 KB

I work a lot with dates in my docs so have built a reference/education doc that gives a ton of tricks and help if you want to do a deeper dive → Dates, Dates and More Dates

4 Likes
3

I like the WeekDayName() = “Friday” approach, it is user friendly. I thought of this variation applying the WeekDay() logic (Friday is day number 5):

Sequence(Today(),Today()+6).Filter(CurrentValue.Weekday().Contains(5)).FormulaMap(CurrentValue.ToDate())

1 Like
4

WOW! Thank you! I wouldn’t have come up with that in a million years. Cheers, Scott!

2 Likes
5

Hey! Just for clarities sake - I just realized the formula I gave above was meant to list the days in a week for non-american countries (aka where the week starts on Monday)

If you want to start the week on Sunday, change the weekStart+1 to simply weekStart and turn weekStart+7 into weekStart+6

For your specific use case, what I have you will work perfectly. But in case others see the post later I just wanted to clarify!

1 Like
6

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