Compare year together with month

[jcis]

You can use DateDiff to compare Dates, or Dateadd to add hours, days, months..etc
DateDiff Example: Find the diff in days between 2 dates..

    Dim Ld As Date
    Ld = #12/8/2005#
    MsgBox DateDiff("d", Ld, Date) ' "d" = Days