Thread
:
Months or Years remaining, formatting
View Single Post
#
3
Sandy Mann
Posts: n/a
Try:
=DATEDIF(A1,TODAY(),"y") & " Years " & DATEDIF(A1,TODAY(),"ym") & " Months"
DATEDIF is only documented in XL2000 Help but Chip Pearson has a page on his
website about it:
http://www.cpearson.com/excel/datedif.htm
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"James C" wrote in
message ...
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
--
James C
------------------------------------------------------------------------
James C's Profile:
http://www.excelforum.com/member.php...o&userid=12114
View this thread:
http://www.excelforum.com/showthread...hreadid=468843
Reply With Quote