Calculating the difference in dates

  • Thread starter Thread starter sonar
  • Start date Start date
S

sonar

Ok,

I have found the formula, it is:

=IF(D11<>"",(DATEDIF(D8,D11,"y") & " years, " & DATEDIF(D8,D11,"ym")
" months, " & DATEDIF(D8,D11,"md") & " days"),((DATEDIF(D8,NOW(),"y")
" years, " & DATEDIF(D8,NOW(),"ym") & " months, "
DATEDIF(D8,NOW(),"md") & " days")))

But I still need to know what formula to put into another cell t
calculate how many months it is, so that I can calculate it with th
amount of days accrued per month which is 2.5 days

Any help there please?

Regards
Sonar :rolleyes
 
Back
Top