I have an Appsheet who consist two column, let's both named is Production Date and Expired Date. If column Production Date has 2 years of Expired Date then how the formula in appsheet to calculated it? Let say the example, Production Date is 31/10/2023, therefore Expired Date is 31/10/2025. I want the formula to consider leap years.
Before that, i have created a formula but it is not worked. There was note "DATE function is used incorrectly"
Does anyone know the formula to solve this problem? Please let me know.
Calculate a date two years from a given date
Assume that the given date is 31/10/2023 and the value is in cell A2.
DATE()
=DATE(YEAR(A2)+2,MONTH(A2),DAY(A2))EOMONTH()
=EOMONTH(A2,24)Calculate a date 35 months from a given date
Assume that the given date is 31/10/2023 and the value is in cell A2.
DATE()
=DATE(YEAR(A2),MONTH(A2)+35,DAY(A2)-1)EOMONTH()
=EOMONTH(A2,35)RESULTS