wilg
06-12-2012, 09:45 AM
Hi there. I have a spreadsheet with information on it from column A:V, 400 +/- rows
In column N has a date that a goal is due by that each row has different dates of the year non sorted.
There is approx 400 rows.
I need to sort rows selecting column N so that it descends [U]60 days from today's current day.
eg if one row has Dec 3rd and another row has April 2nd it would be sorted...
Dec 3
Apr 2
etc...
If I use a regular sort it would decent chronologically
Apr 2
Dec 3
I need to sort by what is coming up 60 days from "Today()"
All help is appreciated.
In column N has a date that a goal is due by that each row has different dates of the year non sorted.
There is approx 400 rows.
I need to sort rows selecting column N so that it descends [U]60 days from today's current day.
eg if one row has Dec 3rd and another row has April 2nd it would be sorted...
Dec 3
Apr 2
etc...
If I use a regular sort it would decent chronologically
Apr 2
Dec 3
I need to sort by what is coming up 60 days from "Today()"
All help is appreciated.