|This is pretty straight forward but the thing is we need to know where you dates are and how your worksheet (assuming you are using Excel) is laid out. I have done this many times before but layout is essential so that we can read the dates.|
Using vba you can use the DateDiff function to compare two dates for example, this will return the number of DAYS between dates using "d"
x = dateDiff("d", format(now(),"dd/mm/yyyy"),"01/07/2016")
this will give you 1 as 01/07/2016 is one day ahead of today
Please provide the structure of your worksheet using the Pre tags and we will do what we can to help.