How to Easily Convert Gregorian Date To Hijry in Excell

It very simple to convert it, no program or software need it but simple formula will do it
type to the cell like this
=(text(cell reference which you want to convert to Hijry)-1;"b2dd/mmm/yyyy")
it is done

How about converting today??
it is easy also, jut combine with today()formula to replace cell reference
watch this

and the result is

Happy trying!!
best wishes

Posted by NurKholis