I have a column called > Investment start date which contains the date on which SIP was registered. Say for example 06-05-2023.
Now, I want to create a new column called next Investment date. This column will be the next date when my Investment is supposed to be deducted(mostly in monthly intervals). In this example - 06-06-2023.
Furthermore, I want this next Investment date to be updated automatically once 06-06-2023 is crossed. It should then be updated to 06-07-2023.
Please suggest a workaround since I cannot find any way to dynamically update dates each time.