Returning first day of week

[jimliston]

I need to calculate the date of the first day of a calendar week. (Sunday, February 10 for example). It will obviously always be Sunday. I want to display it as: Work week beginning . I can get the week number easily, but how do I calculate that week's Sunday as a date and return it to my calculation?

 

Thanks

 

Jim

[aaa]

Helo, Jim!

Let([$var=Date(1;1;Year)+(Week_num-1)*7;$var=$var-DayOfWeek ( $var )];$var+1)

It seems this works.

I attached example too.