The column below shows enrollment dates. Unfortunately, I dont have ACTUAL dates. These only count how many days from TODAY the enrollment was done. Is it possible to create a formula that will actually give me a DATE? I need to calculate the one closest to TODAY.
I guess in English it would be something like: TODAY MINUS 1 HOUR = TODAY'S DATE...... or
TODAY MINUS 38 DAYS = APRIL 19, 2013
Age
1 Hour
2 Hours
38 Days
2 Hours
4 Hours
29 Days
29 Days
34 Days
42 Days
48 Days
49 Days
56 Days
59 Days
73 Days
77 Days
78 Days
30 Days
< 1 Hour
Bookmarks