Hello all.
=(A1-(NOW()))/365
The above formula gives me years remaining as "X.XX YEARS" (currently I have the cell formatted as 0.0" years"; )
This is a two-part question:
(a) FORMULA CHANGE: I want to change the formula so that the result is the same, UNLESS [LESS THAN 1 YEAR], THEN "X.XX MONTHS"
(b) FORMATTING METHOD: should i set up a conditional formatting solution, or can I just do this all in one in-cell formula?
Any help would be much apprecieted.
- Jim
Bookmarks