Blog - Age Calculation

Age Calculation

Age Calculation

Advance Excel

Age Calculation 

 

  इससे हम हमारी Age (month, year,   days) का पता कर सकते हैं

 

  

 

   Current date =TODAY()

 

   Year =DATEDIF(B2,C2,"y")

 

   Month =DATEDIF(B2,C2,"ym")

 

   Days =DATEDIF(B2,C2,"md")

 

   Day       =Choose(weekday(B2),"sun","mon",

             "tues","wed","thus","fri","sat")

 

  Age =Concatenate(D2,"year",

            E2,"month",F2,"day")

 


357 9 months ago