Need Alternative

[K Vinod]

Dear Team,

Is There any alternative method to calculate the service period in the Organization without using DATEDIF Function.

If have Please inform me.

 

[NARAYANK991]

Hi ,

There are alternatives to the DATEDIF function , in the sense that what ever results the DATEDIF function will return , identical results are possible using a formula which makes use of logic.

If you upload your workbook with adequate data in it , and specify the variations that will occur , this alternative formula can be developed.

Narayan

 

[K Vinod]

Hello Narayan,

Thank you for your responce.

But requesting you to share the alternative methods & the procedures.

i am using the datedif function to calculate the service period in the organization using below formula.

=IFERROR(DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months "& DATEDIF(D2,E2,"md") & " days ","NA")))).

Now I want to replace this formula with Alternative formula in short form so requesting you that if you have any alternative method to calculate the service period Please forward the formula or Kindly upload the excel file with alternative formulas.

Thank You

 

[NARAYANK991]

Hi ,

Since other formulae will need to do the same thing that the DATEDIF function does , it is very unlikely that these formulae will be shorter than what you have posted. If anything they will be longer , using more Excel functions.

Narayan

 

[K Vinod]

Dear Narayan,

Thank you for your Reply.