View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default diference in dates

I think Pierre wants the number of months between the dates.

Fpormat as general:
=IF(A2=B2,"The dates are the same.",IF(B2A2,MONTH(B2-A2),"The first
date is later than the second."))

Cliff Edwards