Forum Discussion
Lynn McKie
Oct 31, 2017Copper Contributor
Decimal to date
Hi there hoping someone can help me. I am creating a spreadsheet currently looking at differences in data. However the data i have currently gives ages as 9.2 years (9 years 2 months) but when do...
SergeiBaklan
Nov 01, 2017Diamond Contributor
Hi Lynn,
Please clarify how your initial data is presented. For example, if that's the number 8.1 (which is equal to number 8.10) how do you know that's 8 years and 1 month or 8 years and 10 months? Or you have text here?