date matching problem.

[timtim89]

Hi,

I have two dates in the format mmm-yyyy, but for some reason they do not match - that is, I cannot used match function.

Please see the attachment. The two dates are copied from the source with "Keep source formatting".

Thanks in advance!

Timo

[popipipo]

Format is how you see anything in a cell not the real value
Change format in 'dd-mmm-yyyy' and you see why there is no match.

[timtim89]

Thanks a lot, cant believe it didn't see that myself! Great with instant help (:

[grasstoe]

If all you care about is whether the months or years match then reference that part of the data. Example from your sample =MONTH(E8)=MONTH(B5)
or
=AND(MONTH(B5)=MONTH(E8),YEAR(B5)=YEAR(E8))
Cheers
grasstoe