Compare Date Range Across Columnss by Exactly 5 Days

Hello all,

Sorry if this is too general a question. I do not use excel often and also it is my first time here.

My dilemma is this:

I have two columns of date ranges. I need to compare the date range in column 2 to date range in column 1 to find which dates are more than 5 days past the first date.

example February 01,2017 February 05, 2017
February 06, 2017

I just need to find everything over five days but all the dates in column A are different.

VLOOKUP or IF Statement.. or? How do I write it for this?


thanks for assistance,