Formula

[Diane]

What formula can I use to determine a person's age (as of
September 1, 2003) if I have their date of birth and
result must be shown as 3.06 for 3 years, 6 months.

Thanks!

 

[David McRitchie]

DATEDIF Worksheet Function is available in all versions of Excel
but is in HELP file only in Excel 2000. For a description and
examples such as your question see Chip Pearson's page
http://www.cpearson.com/excel/datedif.htm

Showing decimal for a month you would be in your own
concatenation as are the other examples, but I think most Excel users
would find such practice of using a single decimal point for non decimal
fractions or other usage annoying at best.

For the upper date I would use DATE(2003,09,1)

 

[Harlan Grove]

The earliest version of Excel I've ever used was version 4 with XLM
macros.I'v never even seen anything before that,Versions 1 2 and 3 you
speak off,what years were they released?Datedif was a function
"borrowed" from Lotus anyway so probably thats the reason its not
listed.

Excel 1 existed only on Macs, and it was released in the mid-1980s. Excel
2.something for Windows 286/386 was released in Fall 1987, and I was using it
under Windows 386 by Spring 1988. Excel 3 came out just after Windows 3.0, so
sometime in 1990, IIRC. In theory XL3 was released after 123R3, but I don't
recall it being much more than XL2 rebuilt for Windows 3 (a precursor to the no
big deal XL5 to XL95 'upgrade').

 

[Thomas]

IIRC Excel 5 was 16 bit and XL95(ver7)was 32 bit.Correct?There was no 6.