Setting DATE value based on condition

Hi. I have a table cut up into multiple slices. One slice has a column [Date of Treatment] and another slice had [Date of Transfer]. I want the [Date of Transfer] column to remain blank until the [Date of Treatment] column is at least 14 days old. So I am trying both these expressions but neither are working

IF(TODAY()>([Date of Treatment]+14),TODAY(),"")
IF([Date of Treatment]<TODAY()-14,TODAY(),"")

Am I on the right track here?

Thanks.

0 13 1,420
13 REPLIES 13
Top Labels in this Space