Hello,

I have many rows with a date column. I am trying to calculate a new column
(Week_Ending) so it will return a date field (every Sunday) that the date
fall in that week using a weekday function, but could not get it to work.

Example:
Date Week_Ending
2/1/08 2/3/08
2/2/08 2/3/08
2/3/08 2/3/08
2/4/08 2/10/08
2/5/08 2/10/08
2/6/08 2/10/08
2/20/08 2/24/08

Thanks