I have a worksheet named "Sorted_Data" which has columns as follows:
Name (A) , Date1 (B), Date2 (C), Date3 (D), Date4 (E), Date5 (F)
I would like to sort the sheet by columns B to F, sending the row with the closest date to today to the top of the list.
I would also like to format the dates with a color if the date is less than 28 days from today.
A header row exists.