Hi,
I have a project timeline in excel (example attached), column D is the task start date and column E is the task finish date and Cell H7 has a specific date entered. In column H i would like to say "yes" if the start date or end date fall with 3 months (before or after) the specified date in H7. I have thought about an IF EDATE formula but can’t work it out/not sure if it is the right path to go down. Any help would be greatly appreciated
Bookmarks