I am absolutely new to this and searching desperately to an answer to following task:

If the date of cell E2 has arrived cell H2 updates itself to "valid" and if date of cell F2 has arrived Cell H2 updates itself to "invalid"

CodePudding user response：

Try

=IF(isdate(E2);"valid";if(isdate(F2);"invalid";))

in Cell H2

If E2 is a date, it will return "valid"

If not, it will check F2

If F2 is a date, it will return "invalid"