Translate This


Wednesday, April 11, 2012

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

No comments:

Post a Comment

Jangan Lupa Berilah Komentar!!
Trimakasih atas kunjungannnya.

Related Posts Plugin for WordPress, Blogger...