Problem about convert Gregorian dates to solar date (shamsi)or (persian date) in Excel 2016

[Mahdi]

Hi
sorry for my bad English language writhing ... i have a problem with convert date ... i want to write Gregorian dates in as like " A2" then it will convert to Shamsi (Persian date ) in "B2" ... i have a add-ins for excel 2013 that it's Ok for this version but it's don't work in excel 2016
what should i do for solve this issue?

my Name is Mahdi Saadatmand from IRAN
and my Email is :REMOVED
best regards.

 

[Derek Brown]

I don't have the answer for you but I do wonder if you have changed from 32-bit Office to 64-bit Office?
Some add-ins may only work in 32-bit Office.
What is the add-in that you are using?

 

[Mahdi]

Hi Derek
I'm using of Excel 2016 that, it's installed in Win 8.1 x64.

 

[Derek Brown]

You need to find out whether Office is 32-bit or 64-bit:
https://support.office.com/en-gb/ar...-I-using-932788b8-a3ce-44bf-bb09-e334518b8b19
https://liberty.service-now.com/kb_view_customer.do?sys_kb_id=7e56d58e358829405af1cb6de5727f5a
This may also be useful:
https://support.office.com/en-gb/ar...ice-2016-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261

You did not say which add-in you are using.
The website may then say if it will run in 64-bit Office (Excel).

 

[Mahdi]

sorry , i'm using of Excel 2016 x64
thanks for links

 

[Derek Brown]

You need to check with the website for the add-in to find out whether it is compatible with 64-bit or whether you need to get a later version (if available) of the add-in.

 

[Mahdi]

thank you .