Calculating the difference in dates

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
 

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

Similar Threads

Add/Sum up months, years, dates 4
Excel formula calculating age 4
How do I calculate exact difference between two dates in y,m,d. 8
problem summing columns with dates 2
DATEDIF vs. simple difference 5
A mathematical formula question??? 3
Totaling DATEDIF SUMS 4
Calculating the difference in dates 2

Top