date formula

[34laraider]

Can anyone help me create this function?

I need to be able to input two dates and get the number of years (as an integer) between the dates.
For example:
1/4/2003 - 5/14/2008 would return 6 because we are currently in the sixth year.

6/11/2003 - 5/14/2008 would return 5 because we are in the fifth year.

I would also need to be sure that 5/14/2003 - 5/14/2008 would return 5.

Any help is greatly appreciated!

[protonLeah]

Sorry, but I don't agree with your expected results. Using birthdays as an example, a child born on 1/4/2003 would celebrate his 6th birthday on 1/4/2009 not 1/4/2008. So, using the DATEDIF fn to return years, you get 5 not 6 years. If you use that fn to return days and divide by 365 you get 5.36 years which can't legally be rounded up to 6.

[shg]

In China, a person is one year at birth ...

[carsto]

try this:
=ROUNDUP(ROUND(YEARFRAC(start_year,end_year,1),2),0)

since we're rounding to a two place decimal first then rounding up to the next whole number it should take care of the 5/14-5/14 issue

you have to have the Analysis ToolPak Add-In enabled to use the YEARFRAC