Solved: Calculate start date + 3 months = DATE - Page 2

wsaico · 04-10-2021 07:07 PM

I have a column [DELIVERY DATE] of a product, and the product has another column of [DURATION] example 3 months I want to calculate [DELIVERY DATE] + [DURATION] and the result I expect is in DateTime format in the [EXPIRATION] column
I really appreciate your help I’m new to appsheet

Suvrutt_Gurjar

Hi @wsaico ,

Thank you for posting the screenshots. From the details shared , it sounds that you have made an error while entering the formula. You have entered [Expiration Date] in the formula , that is DAY([Expiration Date]) which is incorrect.

I have clearly mentioned that the formula has [Delivery Date] in all the places.

Please remove [FECHA VENCIMIENTO] from formula and include [FECHA ENTREGA] INSTEAD.

Please try

EOMONTH([FECHA ENTREGA], ([Vida util] -1))+DAY([FECHA ENTREGA])

View solution in original post