Where cell contains specific text then subtract D1-today()

[brian_2me]

Hi Guy's,

Please see file attached,
column A-C = mock up data
column D = formula required "where C3 = "Pending Review", calculate B3-today()"
Column E = expected result

[Pete_UK]

Try this in D2:

=IF(C2="Pending Review",B2-TODAY(),"")

Format as General, then copy down as required.

Hope this helps.

Pete

[brian_2me]

Thanks worked a dream, was missing "" from my attempts