How to add Today() to number to calculate a date in the future?

[FTong]

I am having a problem calculating a date in a Date column.

I want to define “INITIAL VALUE” of the EstimatedTimeOfCompletion using a formula as follows:

Today()+TimeAllowanceDays

However, this seems not to be working as I only get ‘Today’s date’ and not ‘Todays date + 21 days’.

I have tried the following as INITIAL VALUE for EstimatedTimeOfCompletion:

a) Today()+1 <-Returns Tomorrow’s date
b) Today()+TimeAllowanceDays <-Returns Today’s date.
c) Today()+[TimeAllowanceDays] <-Returns Today’s date.
d) Today()+TimeAllowanceDays+1 <-Returns Tomorrows date.

Question:

1. What is the correct way to call the value of another field into a formula.
2. Any other tips that may help would be appreciated.

PS: I already read the following links:(and they are not clear about this).

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

help.appsheet.com

DATE()

Date from Date, DateTime, or Time

[Marc_Dillon]

Felix.P_Tong:

What is the correct way to call the value of another field into a formula.

The column name inside of square brackets.

TODAY() + [number of days]

is correct here.