dubyayoung
New member
- Joined
- Oct 5, 2012
- Messages
- 11
- Reaction score
- 0
- Points
- 0
I am tracking when something is approaching a due date. I want to subtract the due date from the current date (already referenced in another cell, if that helps) and have the results show as time remaining in a cell as follows:
If > 1 year, show time remaining as "x.x Years"
If < 1 year, show time remaining as "x.x Months"
If <=90 days, show time remaining as "x Days"
If <0, show the words "Overdue"
So depending on the time remaining, I would like the result to show in the cell like these examples: 2.2 Years, or 10.5 Months, or 72 Days.
Can anyone come up with a good way to do that?
If > 1 year, show time remaining as "x.x Years"
If < 1 year, show time remaining as "x.x Months"
If <=90 days, show time remaining as "x Days"
If <0, show the words "Overdue"
So depending on the time remaining, I would like the result to show in the cell like these examples: 2.2 Years, or 10.5 Months, or 72 Days.
Can anyone come up with a good way to do that?