The following formula calculates the number of years between two dates. This formula assumes that cells A1 and B1 both contain dates:

=YEAR(A1)-YEAR(B1)

This formula uses the YEAR function to extract the year from each date and then subtracts one year from the other. If cell B1 contains a more recent date than the date in cell A1, the result will be negative.

Note that this function doesn’t calculate full years. For example, if cell A1 contains 12/31/2007 and cell B1 contains 01/01/2008, the formula returns a difference of one year, even though the dates differ by only one day. See the next section for another way to calculate the number of full years.

• Wasting a life The man who views the world at 50 the same as he did at 20 has wasted 30 years of...
• ITALY - Embryonic stem cells: Waldensian church doubles "eight per thousand" allocation to fund stem cell research. The Waldensian community in Italy has decided that next year, it will double its so-called “eight per thousand” allocation from...
• Don't use your time profitably? Sue someone! If keeping your day job is the cake, then investing in yourself outside of your day job is at least...
• Central San Diego Real Estate Market - Mid Year Snapshot Of Median Prices (2006) - Single Family Homes Central San Diego Real Estate Market - Mid Year Snapshot of Median Prices (2006) - Single Family Homes As of...
• TaylorMade Golf 2009 Burner Driver (Regular,10.5�,Right Hand,RE*AX SuperFast 49 Graphite) User Reviews Send this to a friend TaylorMade Golf 2009 Burner Driver (Regular,10.5�,Right Hand,RE*AX SuperFast 49 Graphite) Manufacturer: TaylorMade Customer...