I have Column A which has a series of dates - non-unique.
In Column B I need to have the week-ending date.

For example -

03/08/05 03/13/05
03/08/05 03/13/05
03/15/05 03/20/05
03/15/05 03/20/05
03/16/05 03/20/05
03/17/05 03/20/05
03/17/05 03/20/05
03/17/05 03/20/05

and so on.

Any help is appreciated.

Heather