You could use DATEDIF in your formula to derive the answer in years
and months directly - Chip Peasron explains how he
http://www.cpearson.com/excel/datedif.aspx
Hope this helps.
Pete
On Mar 12, 6:52*pm, Chris wrote:
Hi - need some help here...
Does anybody know how to display a number as years and months?
I would like to show 1.8 as 1 year, 9 months instead of a decimal.
The 1.8 I get by subrtracting my start date from today's date....
=today()-Cell with start date/365