Hi guys,

I was wondering ,
how do you add in another further conditioning on this condition for a blank cell when there is nothing/blank on the input cell??

=IF(TODAY()<D6, "VALID",IF(TODAY()=D6,"DUE","EXPIRED"))

PLs see attached for more info on what i mean.

Hope someone could help me thanks