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.
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
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”)
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
