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.

• Obama's $819 Billion Economic Stimulus Plan I'm sure you've heard by now that the House of Representatives passed Obama's economic stimulus plan.  Not a single Republican...
• One (1) Year in 120 seconds video [/caption] In 2008, Eirik Solheim of Oslo, Norway, filmed his backyard regularly for a year and compiled the results into...
• Delta View Golf Course Delta View Golf Course is located in: Pittsburgh, CA Phone: (925) 252-4080 Website: http://www.deltaviewgolfcourse.com Course History: This course was originally...
• bahh! im so shy around boys!? HELP? ahh... im shy around guys i like. tomorrow me and a few of my friends are going to the mall,...
• CNN's Rick Sanchez Lies to Cover Obama's Massive Spending JAMES SIMPSON: Rick Sanchez made a bald-faced lie on CNN yesterday in defense of President Obama’s budget numbers. He was...