Ironman5089
New Member
- Joined
- Oct 8, 2019
- Messages
- 4
I am trying to compare the date in D4 with date in N4. If date in D4 is greater than N4, I want a comment "Expired".
It works for me
D E F G H I J K L M N 4 20/09/2019 ok 25/09/2019 5 27/09/2019 Expired 25/09/2019
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>Lists
Worksheet Formulas
Cell Formula I4 =IF(D4>N4,"Expired","ok")
<thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Do you have calculation set to automatic, or manual?