Which I don't think is anything other than I'm not versed in this stuff well enough ...
Let's say you have two dates (StartDate and StopDate)
StartDate = Range("A3") 'assuming it's already a date
StopDate = Range("A4") 'assuming it's already a date
StopYear = Year(StartDate) + 1
AfterThisDate = "12/31/" & StopYear
I need to check to see if the StopDate is less than the AfterThisDate ...
If StopDate < AfterThisDate Then
'Throw an error
However, it's not calculating unless the dates are equal ... Am I missing something?