ExcelBanter - Week Ending formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Week Ending formula (https://www.excelbanter.com/excel-discussion-misc-queries/149844-week-ending-formula.html)

Cindi

Week Ending formula

I need a formula that gives me the weekending date. Any helpd is greatly
appreciated.

Teethless mama

Week Ending formula

=7-WEEKDAY(A1)+A1

"cindi" wrote:

I need a formula that gives me the weekending date. Any helpd is greatly
appreciated.

Ron de Bruin

Week Ending formula

Hi cindi

For ISO weeks you can find formulas to a find the date for a Year/Week number on this page
http://www.rondebruin.nl/isodate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"cindi" wrote in message ...
I need a formula that gives me the weekending date. Any helpd is greatly
appreciated.

All times are GMT +1. The time now is 05:57 AM.