Help...

=IF(I3="Closed","Closed",D3-$D$1)

Column I = Open or Closed
D1 = =TODAY()
The rest of column D = =DATE(YEAR(C3),MONTH(C3)+6,DAY(C3))

Can you return a formula in an IF statement as i get a circular ref

Thanks
Andy