Calculating dates using the TODAY function

[xangi]

Okay sorry to harass you all, but I have homework due in 2 hours and I can't figure out how to nest this function properly.

The instructions say: "Using the TODAY function and the date in Cell F5, enter a formula in Cell G5 to calculate the number of YEARS of service the employee has been with the company."

The date in Cell F5 is "7/20/2009"

Any possible help is much appreciated...

[jeffreybrown]

See if this helps...

http://www.cpearson.com/excel/datedif.aspx

[xangi]

doing =DATEDIF(TODAY(), F5, "Y") gives me the date "1/3/1900"

[jeffreybrown]

Try turning those dates around...

=DATEDIF(F5,TODAY(),"y")

From Chip's site:

The syntax for DATEDIF is as follows:

=DATEDIF(Date1, Date2, Interval)

Where:
Date1 is the first date,
Date2 is the second date,
Interval is the interval type to return.