Need Help!

[cbryan15]

Hi! Is there a ISDATE native formula in excel? I am trying to enter a formula in one cell (cell Z11) in which, it will display TRUE if T11 finds the same value or date in cells B11:R32. Please take note that I formatted cells T11 and B11:R32 as [$-409]d;@ so that it would only display as number of day (ex: 05 March, 2013 will display as 05).

Kindly help. Thank you very much in advance!

 

[Firefly2012]

Hi

Can you just use COUNTIF?

=COUNTIF(B11:R32,T11)>0

 

[cbryan15]

I really appreciate your help! I am not good in excel, that is why. Thank you so much @Firefly2012!

 

[Firefly2012]

You're welcome