Help To Automate the Comment Row

Please find an attached file, on it there's red painted cells with the further instructions.

Hi,
What is PWT NPWT POT NPOT?

Paid Within Target (PWT)
Not Paid Within Target (NPWT)
Paid Off Target (POT)
Not Paid Off Target (NPOT)

Belinda

hi,
is this giving you the required result?

G2 and down:
=IF(TODAY()-E2<=14,"PWT",IF(AND(TODAY()-E2<=14,F2=""),"NWPT",IF(TODAY()-E2>14,"POT",IF(AND(TODAY()-E2>14,F2=""),"NPOT"))))

Or perhaps this one, if PWT and POT are calculated on column "F":

=IF(F2<=14,"PWT",IF(AND(TODAY()-E2<=14,F2=""),"NWPT",IF(F2>14,"POT",IF(AND(TODAY()-E2>14,F2=""),"NPOT"))))