Hijri Format - "B2dd/mm/yy" – input the date in Gregorian format, and it will be converted to Hijri format as well as displayed. It is a valid Excel date, completely switching the format from Hijri to Gregorian.