WEEKDAY() begins counting from Sunday. i.e., Sunday=1, Saturday=7
My current expression [DATE]+7-WEEKDAY([DATE]) gets the weekending date of [DATE]
I need an expression that gets the weekending date with the first day of the week being Monday and the last being Sunday, Monday=1, Sunday=7
Any ideas would be appreciated.