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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.