Calculating the difference in dates




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?

Sonar :rolleyes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question