Excel 2007 : Subtracting date

[operat01]

Hello All,

long story short; I need to find a way to subtract pre-set dates. E.g:
subtract 11.11.2006 from 13.10.08.

11.11.2006 is the employement day and 13.10.08 is (was) today's date. I need to know how may months and years an employee has worked so far.

Thanks in advance,
Ad's

[Paul]

Hi operat, and welcome to the forum.

You can use Excel's DATEDIF function for this (see here for examples: http://www.cpearson.com/excel/datedif.aspx)

In your case, something like this might work, where A1 has the hire date and B1 has '=TODAY()':

=DATEDIF(A1,B1,"y")&" year(s), "&DATEDIF(A1,B1,"ym")&" month(s)"

This will produce a result like:

1 year(s), 11 month(s)