if cell value is hijri or gregorian date?

thank you TMS! Attached is the sample workbook!

Maybe this solution will work?

if Year(date1) <=1900 then
   'its a hijri date
else
   'its a gregorian date
end if

Please correct if my idea is wrong!

Thank you!