Determine if date is expired (if statement)

[adorlytanglao]

I have a list of employee working in our company with expiry dates of their national ID. I already tried a nested if statement and its giving two output Expired and Valid. My one issue is that when it reaches to an empty cell its says "Expired", even though I'm expecting it to be empty also. Please let me know how can i upload the file. Or i think we can just use the same starting cell where the date is entered "F3". So im currently using this code:

=IF(F3="", "", IF(F3<today(), "expired",="" "valid"))[="" code]<="" html=""></today(),>

 

[adorlytanglao]

Its deleting the code after the less than symbol


=IF(F3="", "", IF(F3[lessthansymbol]TODAY(), "Expired", "Valid"))

Can you tell me also how to fix that.<today(), "expired",="" "valid"))<today(),="" "valid"))[="" quote]<="" html=""></today(),>

 

[vlady]

check if your calculation is set to automatic

FORMULAS Menu -> Calculation Option -> AUto..

 

[BM604]

First time I am able to help someone. Not sure if this helps but try:

=IF(F3="","",IF(F3[I][lessthansign][/I]TODAY(),"EXPIRED","VALID"))

<today(),"expired","valid"))[ code]<="" html=""></today(),"expired","valid"))[>

 

[adorlytanglao]

@vladyThe calculation option is already set to auto. @bm604 the code is the same to the one I'm using.

 

[adorlytanglao]

I don't know what im doing before but the code bm604 gave me worked but its the same with the one i posted but it's not working. Anyways, thank you for responding. I still want to know how to fixed the issue about the code being deleted after the lessthansign.

 

[BM604]

They do look to be the exact same. I didn't even notice! Anyways glad to have helped... if I did!

I am not sure about the less than sign either... it cut the code off like in your original message.