if cell value is hijri or gregorian date?

I think you'll need to post a sample workbook with examples of the dates ... ideally, all the months.

I suspect that a Gregorian date will show up as a number and a hijri date might be text but that's just a guess.


Regards, TMS

For your formula, you could use:

Formula:

Please Login or Register  to view this content.

Or, for a more accurate calculation (text string output):

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E	F
1	EMP_NAME	FILENO	BIRTHDATE	AGE
2	Employee 1	546	03/02/1977	37	37 Years, 11 Months, 4 Days
3	Employee 2	858	1/7/1397	hijri date	hijri date	error because date is hijri/arabic
4	Employee 3	549	30/8/1978	36	36 Years, 4 Months, 8 Days
5	Employee 4	554	03/02/1978	36	36 Years, 11 Months, 4 Days
6	Employee 1	770	19/11/1978	36	36 Years, 1 Months, 19 Days
7	Employee 1	638	15/10/1979	35	35 Years, 2 Months, 23 Days
8	Employee 1	764	13/2/1979	35	35 Years, 10 Months, 25 Days
9	Employee 1	843	20/2/1399	hijri date	hijri date	error because date is hijri/arabic
10	Employee 1	310	2/6/1400	hijri date	hijri date	error because date is hijri/arabic
11	Employee 1	568	23/1/1980	34	34 Years, 11 Months, 15 Days
12	Employee 1	804	06/04/1980	34	34 Years, 9 Months, 1 Days
13
14
15					D2:	=IFERROR(INT((TODAY()-C2)/365.25),"hijri date")
16					E2:	=IFERROR(DATEDIF(C2,TODAY(),"Y")&" Years, "&DATEDIF(C2,TODAY(),"YM")& " Months, "&DATEDIF(C2,TODAY(),"MD")&" Days","hijri date")
17

Regards, TMS

I found the following code in an Access Forum and it works, unchanged, in Excel 2007.

Please Login or Register  to view this content.

Assuming that the calculation is accurate (which I can't really check), this should meet your needs.

See the attached updated sample workbook.

Regards, TMS

Having read the other thread in more detail, I understand that the converting from hijri dates to Gregorian dates can "sometimes/normally" be a day out.

However, there were reports that the calculation could be two days out.

Don't know if this is a big deal or not.

Regards, TMS