Converting dates into years

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

james - 04 Apr 2008 13:00 GMT

Given a date how do i in excel calculate the number of years

Reply to this Message

Pete_UK - 04 Apr 2008 13:23 GMT

If you mean the difference between that date and today's date, then
you can use the DATEDIF function. However, it is only included in
Excel Help for version 2000, but fortunately Chip Pearson explains how
to use it here:

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

> Given a date how do i in excel calculate the number of years

Reply to this Message

Jordon - 04 Apr 2008 20:16 GMT

> Given a date how do i in excel calculate the number of years

Later date minus earlier date divided by 365 (formated
as a number).

Signature

Jordon

Reply to this Message

Rate this thread: