<!-- / icon and title --> <!-- message --> I have a column of cells with due dates, that look like:
5 days prior
2 days prior
2 weeks prior
1-3 days prior
I need to get the number of days, and change if its listed as weeks, or in the case of the 1-3 (or similar), the larger of the numbers...
I am clueless on this one! I appreciate any help!
cheers.
ps - i accidentally posted this in 'general discussion', so i am re-posting it here.
5 days prior
2 days prior
2 weeks prior
1-3 days prior
I need to get the number of days, and change if its listed as weeks, or in the case of the 1-3 (or similar), the larger of the numbers...
I am clueless on this one! I appreciate any help!
cheers.
ps - i accidentally posted this in 'general discussion', so i am re-posting it here.