Calculate age on specific data

[Paul Meems]

I'm trying to recreate an Excel sheet with XlsIO which was initially created with Excel.

Most columns I can figure out but I'm struggling with calculating the age on a specific date.

I open an existing xlsx-file as a template and in this template the date is set in cell D1

Next, I loop through a dataset and write data of persons starting at row 7.

Column F holds the DOB of the person, in column G I need to calculate his age in years.

In Excel this formula is used:  =DATEDIF(Start_Date, End_Date, Unit), making =DATEDIF(F7, D$1$, "y") in my example.

What is the XlsIO equivalent?

Thanks

[Abirami Varadharajan]

Hi Paul, 

 

Thank you for contacting Syncfusion support. 

 

Currently, we don’t have support to calculate DATEDIF function. We don’t have immediate plans to implement this feature as Excel also calculates incorrect results under certain scenario. Please refer the following link. 

 

Link: https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c  

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami 

[Paul Meems]

Thanks for the response. I already anticipated and found another solution.

Leave the original formula in the template and just copy it to the new cells. Then it works fine.

I also need to change the formula to =GEH.GET.(($D$1-F7)/365) to get it to work.

Support provided a full working sample at 132506 

[Abirami Varadharajan]

Hi Paul, 

Thank you for updating us. 

We are glad that your requirement is fulfilled. Please let us know if you need any further assistance. 

Regards, 

Abirami.