Year Expression

[james38]

Hey All,

Im new to appsheet and I am working on an expression that I am probably making a huge mess of.

I have a column called [CONDITION] which has an enum list 1-5 value
I also have a column called [DATE] which is todays date

I would like the user to select [CONDITION] “Which is a year value” and my expression would be as follows:
[Date]+([CONDITION]*365.25)

This Expression will fill a blank column called [renewal date].

What I want it to show is the date in which the user must replace an item

in data terms it would be [05/04/2021+(2x365.25 days) hopefully displaying = 05/04/23

I hope that makes some sense to somebody lol

[Steve · Accepted solution]

This?

(
  DATE("1/1/" & (YEAR([DATE]) + [CONDITION]))
  + ([DATE] - DATE("1/1/" & YEAR([DATE])))
)

[james38]

Steve you are a legend, works great