Rounding Dates to Weekending Date
 

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

Rounding Dates to Weekending Date
 

=B1-WEEKDAY(B1)+8

I believe this requires the analysis tookpak add in.

"Neil Pearce" wrote:

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

Rounding Dates to Weekending Date
 

On Wed, 2 Sep 2009 07:28:08 -0700, Neil Pearce
wrote:

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