Is there a way to use Evaluate in VBA?

I have this field in excel that depending on the values I need to do various things:

Evaluate AdjustedReleaseDate

If AdjustedReleaseDate is equal to "" then use ScheduledDate

If AdjustedReleaseDate is equal to 10/1/2016 then use ScheduleDate

If AdjustedReleaseDate is within 7 days (not sure how to code) of the start date entered then use ScheduleDate

If not any of the above, then use AdjustedReleaseDate