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
Bookmarks