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
|