I have put together a calendar database comprised of types for days, weeks, months, etc. For the purpose of a naming formula, I was wondering if there was a way to find the beginning and end dates of a week from any date within a week?
For example, today is Tuesday August 17, 2021, which falls in the 34th week of this year. I want to try and make a formula whose output will be the first and last dates of the week. In this case, I would want the output to read August 15, 2021 - August 21, 2021.
Thanks in advance and all the best!