Hi community…
I need your help for issue below:
First column type (date), second column type (number) represent duration. If I want to record automatically the date in 3rd column as a result from adding the duration in 2nd column to date in 1st column. How can execute that?
Thank you in advance.
Solved! Go to Solution.
TODAY() + 1
gives tomorrow’s date.
TODAY() - 1
gives yesterday’s date.
[Date] + 1
gives the date of the day after [Date]
.
[Date] - 1
gives the date of the day before [Date]
.
[Date] + [Number]
gives the date [Number]
days after [Date]
.
[Date] - [Number]
gives the date [Number]
days before [Date]
.
Duration of what? Seconds? Minutes? Hours? Days? Weeks? Months? Years?
Hi Steve. Duration in days.
TODAY() + 1
gives tomorrow’s date.
TODAY() - 1
gives yesterday’s date.
[Date] + 1
gives the date of the day after [Date]
.
[Date] - 1
gives the date of the day before [Date]
.
[Date] + [Number]
gives the date [Number]
days after [Date]
.
[Date] - [Number]
gives the date [Number]
days before [Date]
.
Thank you steve. I will try this.
Thank you Steve. It is solved.
User | Count |
---|---|
41 | |
29 | |
24 | |
24 | |
13 |