View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marie Marie is offline
external usenet poster
 
Posts: 143
Default using datedif formula

I am using a datedif formula to calculate an employee's number of years
worked. I have the hire date and current(sheet) date. I have used the
formula
=datedif(cellwithcurrentdate,cellwithhiredate,"y") . The return is
1/17/1900. What am I doing wrong?