Thread: Date formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard
 
Posts: n/a
Default Date formula

If F1 has a hire date, how would you write the formula to show the number of
years, months, and days in F2, something like today()-F1 or now()-F1. I can't
get it to show the total years, months and days.
Thanks in advance!