software

Hello,

I have been having a difficult time calculating the difference between 2
dates. Specifically, the start date of an employee and todays date. I want
to calculate how long they have been there for reviews etc. I got the
formula below from a microsoft site but it only gives me 0,
years,6months,22.44237... days. I'm trying to get rid of all of those number
after the decimal. Can you help?//Russ
=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)lt;MONTH(A1),AND(MONTH(A2)=MONTH(A1),
DAY(A2)lt;DAY(A1))),1,0)amp;quot; years, quot;amp;MONTH(A2)-MONTH(A1) IF(AND(MONTH(A2)
lt;=MONTH(A1),DAY(A2)lt;DAY(A1)),11,IF(AND(MONTH(A2)lt;M ONTH(A1),DAY(A2)
gt;=DAY(A1)),12,IF(AND(MONTH(A2)gt;MONTH(A1),DAY(A2)lt;D AY(A1)),-1)))amp;quot; months,
quot;amp;A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)lt;DAY(A1),1,0),DAY(A1))amp;quot; daysquot;
0 years,6 months,22.442376620369 days
You are using
=NOW()
to find the current day? (in cell A2)

Try using
=TODAY()