Calculating a future date based on a number of days
I am trying to calculate a future date using the date as it is 'now' + 90 days. I have read a few articles on here but I don't seem to be able to work it out
I want to have the date completed - for example today / expiry term as 90 days and then it populates the expiry date (I can do this in Excel)
Please help :)
Thanks
Michelle
Best Answers
-
If Date Completed is a Date formatted Column and Expiry term is a numeric column. You need to make sure Expiry Date is a Date Formatted column too.
Then in the Expiry Date enter:
=[Date Completed]@row + [Expiry term]@row
That should work.
Kind regards
Debbie
-
Hi @Michelle Bennett
Hope you are fine, if you want to calculate expiry date as a 90 days from today use the following formula
expiry date = Today(90)
and if you want to calculate the expiry date based on date completed and expiry term use the following formula
expiry date = date completed + expiry term ( 12-July-2021 + 90 = 10-Oct-2021 )
but check that the expiry date & date completed columns are date type and the expiry term column is Text/Number type
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
If Date Completed is a Date formatted Column and Expiry term is a numeric column. You need to make sure Expiry Date is a Date Formatted column too.
Then in the Expiry Date enter:
=[Date Completed]@row + [Expiry term]@row
That should work.
Kind regards
Debbie
-
Hi @Michelle Bennett
Hope you are fine, if you want to calculate expiry date as a 90 days from today use the following formula
expiry date = Today(90)
and if you want to calculate the expiry date based on date completed and expiry term use the following formula
expiry date = date completed + expiry term ( 12-July-2021 + 90 = 10-Oct-2021 )
but check that the expiry date & date completed columns are date type and the expiry term column is Text/Number type
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
thanks both - worked a treat :)
-
Excellent, i will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer)
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Easy when you know how - thank you! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!