Formula for dates

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Hi

I am using Excel 2000 and I need to figure out the
difference in months between two dates, such as when an
applicant applied for a doctor(Q8) and when they recieved
one (R8)and have the answer in cell S8. I know its easy
but I tried using =DATEIF(Q8,R8,"m"), but that returned
the NAME# error.

So my sheet would look like this

Date applied Found doctor Patient Waiting time
07/04/03 07/04/04 12

Can you please help??
 
Back
Top