Creating scheduled date from last date given

Vinton Douglas · 10/03/21

Hello

I am having problems creating a formulla .The formula needs to reflect the due date which is: Date of Last PCR Test + 14 days.

I tried the following but its not working:

=[Last PCR Testing]@row + 14 days()

Any help would be grateful

Bassam Khalil · 10/03/21

Hope you are fine, the 2 column must be Date type column then try the following formula and convert it to column format formula:

=IFERROR([Last PCR Testing]@row + 14, "")

the following screenshot shows the result:

Bassam Khalil · 10/03/21

Hope you are fine, the 2 column must be Date type column then try the following formula and convert it to column format formula:

=IFERROR([Last PCR Testing]@row + 14, "")

the following screenshot shows the result:

Vinton Douglas · 10/03/21

Thanks Bassam. Works great.

Bassam Khalil · 10/03/21

Excellent, i will be happy to help you any time.

Best Answer