gregorian

Dear All, Just like my previous inquiry i have a set of Data on the early Gregorian years starting from 100-1900. What is the best way to make the excel understand and format them under dd/mm/yyyyy and do an aging with =today() Thank you.

I am attempting to solve a problem of finding the difference between two times. The times are downloaded and displayed in a single cell i.e. "8363/0031". The first 4 numbers is the Julian Date and the last 4 are hhmm in 24 hour format. I need to subtract one cell from another and display the...

Hi, I have a database for our fleet documentation e.g. expiration date of registration, MVPI and Insurance. Our statistical assistance made an entry in hijra date for each field, e.g. 10/6/1437 We have almost 500 entries for each field and we try using the b1 format to convert it to Gregorian...

Found very useful code to convert Hiiri to Gregorian dates on http://www.islamicsoftware.org/ I found another function which calculates date of Eid Al Adha as a Hijri date. The two functions aside work fine, however if I try to use the code to convert the Hijri date of Eid Al Adha to a...

On column F I have list of expiry dates of residence ID, and they are all in Hijri. I want to automatically have a conversion to be displayed on its adjacent cell on column G to Gregorian. I search this site for similar post and solution but most of them are for older version of Excel.

I have a column of dates on Column F(Gregorian) and it displays the Hijri dates on Column G. What is did is i formatted the all the cells Column G into Home -> Number -> DropDown More Number Formats -> Number -> Category -> Date -> Locale(Location) -> Arabic (Saudi Arabia) Then i just entered...