I am trying to complete a report in MS Excel 2007 and I am needing a little bit of assistance with this situation. Our system has certain tables in the database where the Sunday's Date (Week Ending Date) is used instead of the week Date.

I was wondering if there is a way to take any date and calculate the Date for the previous or following Sunday's Date.

Thanks for any help/suggestions!