Hello everyone!
I am having an issue with an automation i always get error when i create a filter.
i would like to connect my excel Microsoft, when i update a cell date i would like it to be populated in 6 months time and then send an email to the client from outlook for the reminder and get a time and date when it has been sent so the Cell i have is called Remortgage Date (J) when a date is added i want to update the Cell Reminder 6 Months (L)
Let’s say Remortgage Date is 21/01/2026 automatically, i want the cell “Reminder 6 Months” be updated to the 6 months time which is 21/07/2026 and then when it gets close to the time send a reminder email
Appreciate anyone who can help me!