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:
PS: I already read the following links:(and they are not clear about this).
The column name inside of square brackets.
TODAY() + [number of days]
is correct here.
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |