Hi Saliha,

You can't test if a cell contains a date specifically, as dates are just numbers, so you're just as well off testing if the cell is empty or not, which is what the formula below does:

=IF(H4<>"","Cleared",IF(G4<>"",G4+7,IF(E4="",B4+28,IF(AND(B5<>"",C4="Courier"),E4+5,IF(AND(B4<>"",C4="Air"),E4+10,"")))))

Mynda

Asalamo alikum

find the attachment i tried to resolve hope so you would be happy to see it.

Regards

Waqas Munir

Walaikum Assalam Waqas

Thanks for your formula really i am very appreciated.

regards/Saliha

Dear Waqas

possible to update Week instead of Date in Status column

regards/Saliha

Dear Mynda

Thanks for your formula, its working perfectly. can you help to use Week instead of date.

Regards/Saliha

Dear All

anybody please help in this regards

Regards/Saliha

Hi Saliha,

It's not clear what you mean by 'use week instead of date'. The formula doesn't check for a date as such, it just checks to see if the cell is empty or not. Having a week number or a date in the cell will make no difference. Please provide a specific example of what you mean so we can better understand what you're after.

Mynda