Rounding Dates to Weekending Date

[Neil Pearce]

All,

Column A contains a list of dates.

Is there a means by which I can list the weekending date, which is always a
Sunday, adjacent to the dates in column B?

Thanking you in advance,

Neil

 

[Sean Timmons]

=B1-WEEKDAY(B1)+8

I believe this requires the analysis tookpak add in.

 

[Ron Rosenfeld]

All,

Column A contains a list of dates.

Is there a means by which I can list the weekending date, which is always a
Sunday, adjacent to the dates in column B?

Thanking you in advance,

Neil

Sean's solution will give you the subsequent Sunday if you enter a Sunday.

e.g.


Sunday, April 12, 2009 --> Sunday, April 19, 2009\

Since your next week does not begin until Monday, you might want to return the
same date if the subject date is a Sunday, For that, use:


=A1+7-WEEKDAY(A1+6)


Oh, and this does NOT require the ATP. It is a native Excel function.
--ron