Function: Populate Field with Date of 2 weeks following another date field
Can someone please create a Function for me to populate a date field with a date that is 2 weeks after the value in another date field. (I cannot use a formula field.)
Field API names are "Date1" and "Date2", both formula fields. If Date1 is populated with a date then Date2 should reflect the date of two weeks after date1's date. "Date2" should update every time "Date1" is updated.
Example:
Date1: 1/1/2022 (Manually populated)
Date2: 1/14/2022 (automatically populated)
Can someone help? It seems simple enough but I still need help :)
PS. the reason I can't use a formula field for this is because Zoho doesn't offer enough formula fields for Zoho One users. They've rejected my request for more formula fields so this is my only option. Thanks!