Jan 19 2021 08:34 AM
Jan 19 2021 09:54 AM
= Date-WEEKDAY (date, 2) +1
= Date-WEEKDAY (date, 2) +7
You have to be careful with the calendar week function.
It could be that the calculation is based on the American standard that deviates from the European standard.
* Add a MS Excel file (without sensitive data) to your project, for better understanding. Knowing the Excel version and operating system would also be an advantage.
I would be happy to know if I could help.
I wish you continued success with Excel
I know I don't know anything (Socrates)
Jan 19 2021 10:44 AM
It seems you have a pattern here,
it starts with Sun and end with Sat, and the next row start with the next Sun and ends on Sat
Just select the four cells and drag the courser down and it will auto fill them.
Please find the excel workbook attached
* If my post helped you, please click on like.
Jan 19 2021 11:30 AM
One more variant
Enter in B2 first date, in another cells formulas as on the right and drag B3:C3 down till end of the dates range.
If you are on Excel with dynamic arrays you may use formula
and apply date format to the result