Forum Discussion
IF formula with dates
Hi all, thanks in advance for trying to help me. This is the following situation : I work at a big crewing company and I have to be warned when an individual with a certain nationality (A:A="DK")reac...
Hi Andrew,
You can update the formula as follows to force it to display the date format:
=IF(AND(A:A="DK";TODAY()>=G:G+90);"DO IT";"")&IF(AND(A:A="DK";TODAY()<=G:G+90);TEXT(G:G+90;"mm/dd/yyyy");)
But I suggest to replace it with this:
=IF(AND(A1="DK";TODAY()>=G1+90);"DO IT";IF(AND(A1="DK";TODAY()<=G1+90);G1+90;""))
This is simplified syntax and makes you able to change the format as you want.