View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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