Hi Judy,
There is no simple reliable way to add dates like that.
Use Excel's built-in date facilities instead.
To learn all about calculating with dates, look he
http://www.cpearson.com/excel/datetime.htm#AddingDates
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"JudyT" wrote in message ...
| We have a table that we are adding years and months such as 5.1 is equal to 5
| years and 1 month. What we want to have happend is excel to stop the
| rounding and add the months like months with a base of 12 not 10. We have
| tried, int, rounding, changing formats, precise formatting...and are at a
| loss.
|
| Please help in despartate need.
| JudyT