Excel 2007 : Help with Calculating Previous or Following Sunday's Date

[alrichar]

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!

[Pete_UK]

With a date in A1, this formula will give you the date of the previous Sunday:

=A1-WEEKDAY(A1,2)

even if A1 contains a Sunday date. This formula will give you the date of the next Sunday:

=A1-WEEKDAY(A1,2)+7

but if A1 contains a Sunday it returns that date.

Hope this helps.

Pete