Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

A2=START date B2=END DATE ... CONVERT to YY +MM+DD =DATEDIF(A2,B2+1,"y")&" years " &DATEDIF(A2,B2+1,"ym")&" months "&DATEDIF(A2,B2+1,"md")&" days"

very useful & easy isn't it?

user-image
Question added by Deleted user
Date Posted: 2015/03/11
AHMED ABDULQADER MOHAMMED AHMED AL-ALAS
by AHMED ABDULQADER MOHAMMED AHMED AL-ALAS , عامل إنتاج , نادفوود شركة الألبان والأغذية الوطنية

the is functions give us number days months and years