How to calculate the week ending date ( say Friday ) for the current date

monday Apps & Developers
1

Normally to calculate a weekending date I would use the formula as follows:

Friday = Daynum 6 of the week
Today() + 6 – WeekDayNum( Today() )
If today = Tuesday 04.05.2022
Today() + 6 = 04.11.2022
WeekDayNum( Today() ) = 3
04.11.2022 – 3 = 04.08.2022

Is there a way to calculate this in Monday now? I can’t find a WeekDayNum function.

2

@STeveR

Here’s a version that will work for monday:
ADD_DAYS({Date}, MOD(12 - WEEKDAY({Date}), 7))
OR
ADD_DAYS(TODAY(), MOD(12 - WEEKDAY(TODAY()), 7))

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Should I convert my Integromat account to Make? - YouTube
Contact me directly here: Contact – The Monday Man

1 Like
3

Thanks so much Jim. I came up with a similar solution once I found the WEEKDAY Function

FORMAT_DATE( SUBTRACT_DAYS( ADD_DAYS(TODAY(),6), WEEKDAY(TODAY()) ), “MM/DD/YYYY”)