calculate number of years

[D L Barnard]

the website says to calculate number of years type: =year(A3)-year(A2). when
i type this is i get a weird answer. problem is not that i get the number
signs....i get a date 1900. for example: 1/1/1900 0:00. please advise for
this is for homework, university. thank you to whomever responds.

D L Barnard

 

[Chip Pearson]

Format the cell for General or Number, not Date. Or, you can use
the DATEDIF function:

=DATEDIF(date1,date2,"y")

See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
news:[email protected]...