Hi there,
I’m wondering if there is a solution to allow me to calculate the start of the week date (Monday) if I’ve been given the Year and Week Number ?
Hi there,
I’m wondering if there is a solution to allow me to calculate the start of the week date (Monday) if I’ve been given the Year and Week Number ?
date+mod(8-weekday(date),7)-6
The above works given a date of your choosing. Not sure how to coerce it to calculate based on weeknum.
Worked a dream thanks Robert
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.