Re: check if day difference less than 3 days in a range of dates
I don't quite follow. Are you wanting to compare pairs of dates, like one date in column A against another in column B? or something completely different?
Re: check if day difference less than 3 days in a range of dates
not only between 2 dates, i need to check all the dates (between each date in the column) in the column A to be compared and should be more than 3 days.
Re: check if day difference less than 3 days in a range of dates
Originally Posted by Arnoutdv
Wouldn't this be much easier if the data was sorted on the date column?
Then you only have to compare each cell with the previous and the next cell.
yes I agree, it is not only that column, i have other data in other columns, i m trying to highlight when enter a date (with lesser interval) in the column.
Re: check if day difference less than 3 days in a range of dates
I don't see how you can do it without code if every single date has to be compared against every other date, unless you sort it, as Arnoutdv recommended.