You might want to make use of the Month and Day function. These two functions when you give it a Date, it will return the month and the day respectively.
So something like:
Code:
If Month(Date) = 12 AND Day(Date) = 12 Then
MsgBox "Its the 12th of December"
End If
Will work and pop up the message when its the 12th of Decemeber.