If(AND

[Auxie]

Hi All,

I have this formula:

=IF(AND(G301<>0,G301<>"N/A"),IF(TODAY()>=G301,"Yes","No"),"")

It works for some of my spreadsheet but then stops.

Any ideas why?

 

[steve the fish]

What does works mean? Does G301 contain an error when it doesnt work?

 

[Auxie]

Apologies i should have explained better.

I am tracking expiry dates so column G is the date of expiry.

In some rows it works and the ones it doesn't its not recognizing that the date is in not "Today"

 

[steve the fish]

How does column G get filled in? Try this formula on a date that doesnt work:

=ISNUMBER(G1)

Obviously change the 1 to the correct row. It could be that your dates arent true dates and are being seen to excel as text. Any text is greater than TODAY().

 

[wideboydixon]

Could be that the data in column G has a time component but TODAY() starts at midnight. Try this instead:

=IF(AND(G301<>0,G301<>"N/A"),IF(TODAY()>=INT(G301),"Yes","No"),"")

WBD

 

[Auxie]

Could be that the data in column G has a time component but TODAY() starts at midnight. Try this instead:

=IF(AND(G301<>0,G301<>"N/A"),IF(TODAY()>=INT(G301),"Yes","No"),"")

WBD

Excellent works perfectly. Thank you.