Appsheet calculated expired date spesifiec 2

Question

I have an Appsheet who consist of two columns, let's both named is Production Date and Expired Date. If column Production Date has 35 months of Expired Date, then how the formula in appsheet to calculated it? Let say the example, Production Date is 01/10/2023, therefore Expired Date is 01/09/2026. 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

Answer 1

Update:

You can utilize EOMONTH() function to consider leap year.

calculates the last day of a month some number of months away, factoring in different month lengths and leap years.

Issue:

The error you have was due to the DATE function on AppSheet having different behavior compared to DATE formula in Google sheet.

Your existing formula does work for google sheet but for AppSheet you can manipulate the date by directly calling Production Date column

You can further read the Date and time expressions on AppSheet here

AppSheet Expression:

You can try this AppSheet expression to achieve your desired result

Result:

References:

Date and time expressions

Google Sheet Data function