Adding days to a Date to determine a future date
I am trying to create a formula that will look at the date within the row, look at the frequency and then determine what the next date will be. I am using the following formula:
=[Estimated Date of Charge]@row + [Frequency in Days]@row
Here is the result:
The system is just populating the date in the Estimated Date of Charge field (which is set as a Date field) and adding the Frequency in Days (which is a Text field) to the end.
Also (not sure if it matters), the formula in the Frequency in Days column is: =IFERROR(IF([Frequency of charge]@row = "12 months", "365", IF([Frequency of charge]@row = "6 months", "180", IF([Frequency of charge]@row = "3 months", "90", IF([Frequency of charge]@row = "1 month", "30")))), " ")
By the end of this, I want to set an automation that will be triggered by the Reoccurring Date field to send a notification to a user to confirm that the cost is still applicable.
Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!