Creating scheduled date from last date given

Vinton Douglas

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

Hi @Vinton Douglas 

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

Hi @Vinton Douglas 

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

Thanks Bassam. Works great.

Bassam Khalil

@Vinton Douglas

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