ExcelBanter - Using a col of Dates by day I want to determine a wk ending date.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using a col of Dates by day I want to determine a wk ending date. (https://www.excelbanter.com/excel-worksheet-functions/11481-using-col-dates-day-i-want-determine-wk-ending-date.html)

Ken Espo

Using a col of Dates by day I want to determine a wk ending date.

Using a column of Dates by day I want to determine a wk ending date (sat
date) for each date, based on comparing that date to a range of dates that
are Sun thru Sat.

sebastienm

Hi,
Say a date is in A1, to get the next Saturday use the formula:
=A1+7-WEEKDAY(A1)
Regards,
Sebastienm

"Ken Espo" wrote:

Using a column of Dates by day I want to determine a wk ending date (sat
date) for each date, based on comparing that date to a range of dates that
are Sun thru Sat.

All times are GMT +1. The time now is 06:02 AM.