how can i sync dates in a column with formula?
below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period;
1- In the first step, I enter the end date of the contract and the notice period on a daily basis.
2- The "Deadline for Notice of Termination" field has been formulated according to the notice period. According to the situation in the example, it will send a reminder e-mail to the responsible person 6 months in advance.
The formula in the "Deadline for Notice of Termination" field is as follows;
=[Current Contract End Date]@row - [Termination Notice Period (Days)]@row
So far everything is normal and working. (notifications etc.)
If you notice, the contract expiry date is 5.8.2024. Since 6 months notice is requested, the date is expected to be 5.2.22024.
but the date is 7.2.2024.
I tried removing the weekends to fix this situation. but then it crushes the formula in the "Deadline for Notice of Termination" column.
I would be very happy if you could support me in this matter.