Calculating a future date based on a number of days

Michelle Bennett

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

Debbie Sawyer

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

Bassam Khalil

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

Debbie Sawyer

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

Bassam Khalil

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

Michelle Bennett

thanks both - worked a treat :)

Bassam Khalil

@Michelle Bennett

Excellent, i will be happy to help you any time. Please help the Community by marking it as an ( Accepted Answer)

Michelle Bennett

Easy when you know how - thank you! :)