compare month and year in a date
Ron, Dave
Thank you!!!
--
Afia
"Dave Peterson" wrote:
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
|