Add a selected number to a date

[fred_kayser]

I am trying to add a number of days to a date to come up with a future date and i cant get it to work. In excel the formula is =SUM(E5+L5) Where E5 is the date and L5 is the days to add. In Appsheet, I have the following cells- Date, WD Days. I just need to add those 2 cells to come up with a WD Date. [Date] + [WD Day] = WD Date. how do i get this to work?

[Marc_Dillon · Accepted solution]

[Date] should be a Date-type column
[WD Days] should be a Number-type column
Then you should just be able to do [Date] + [WD Days]

[fred_kayser]

ARGH, I knew it was simple, I spent hours working on this. Thank you. The only problem is i have to click(touch) WD Days for it to calculate the date.

[Steve]

fred_kayser:

The only problem is i have to click(touch) WD Days for it to calculate the date.

True, or make it a virtual column.

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Steve]

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.