calculate number of years
 

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

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




"D L Barnard" wrote in
message
...
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