Find particular text in Date

[krunal123]

# How to Find particular text in Date ??????

i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

 

[Saurabhj]

Hi,

To find year in the cell, use below:
If Cell format is text then use:

=IF(RIGHT(A3,4)="2021","Ok","Mistake")

If Cell format is Date then use:

=IF(YEAR(A3)=2021,"Ok","Mistake")

 

[krunal123]

Hi,

To find year in the cell, use below:
If Cell format is text then use:

=IF(RIGHT(A3,4)="2021","Ok","Mistake")

If Cell format is Date then use:

=IF(YEAR(A3)=2021,"Ok","Mistake")

_______________________________________________
THANKS A LOT ..............................