compare month and year in a date
Another:
=text(a1,"yyyymm")=text(b1,"yyyymm")
Afia wrote:
I have 2 date columns and i need to compare the month and year only,
for example: column a = 31/12/2009 and column 2 is 12/12/2009, the result
should be true
--
Afia
--
Dave Peterson
|