View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Afia Afia is offline
external usenet poster
 
Posts: 7
Default 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