How to format cells to show dates as the week-ending date of that

[Guest]

If I have a range of dates in column A (i.e., 3 different dates in this
column: 7/1/06, 7/5/06, and 7/9/06), I want to format cells in column B to
show the week-ending date (Sunday) for each particular dates from column A.
For example, if column A has 6/29/06 date (Friday), column B should show the
week-ending date for that week as 7/2/06 (Sunday). Please advise! Thanks!

 

[Bob Phillips]

=$A1+MOD(8-WEEKDAY($A1),7)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

If I have a range of dates in column A (i.e., 3 different dates in this
column: 7/1/06, 7/5/06, and 7/9/06), I want to format cells in column B to
show the week-ending date (Sunday) for each particular dates from column A.
For example, if column A has 6/29/06 date (Friday), column B should show the
week-ending date for that week as 7/2/06 (Sunday). Please advise!

Thanks!