combining if functions for date based TAT calculation

Hi,

I have 2 columns with dates one which is projected delivery date & the other the actual delivery date. I want to populate "Delivered within TAT" if the delivery happens before the projected delivery date & "Delivered out of TAT" if delivered after the projected delivery date, for this I have the formula which is IF(AC2>D2),"delivered Out of TAT","delivered Within TAT"), but if the delivery date is blank that 00/00/0000 then I want it to populate "Within TAT Yet to be delivered" for which I am not sure what needs to be the formula! Please help.

I tried this =IF(AD2<1, "Within TAT Yet to be delivered",""), IF(AND(AC2>D2),"delivered Out of TAT","delivered Within TAT"), but it gives me a "#Value!" error

Urgent Please help!! Thanks in advance :-)

Regards,
Smitha

Thanks Martin!!!! You bailed me out :-)

Regards,
Smitha

Originally Posted by Richard Buttrey

Maybe

Formula:

Please Login or Register  to view this content.

Thanks Richard! It works great :-)