Using Excel's functions with Hijri calendar

EyadAlharbi 

There are many roads leading to Rome, and there are many roads leading to a solution in Excel.

You could do it with cell formatting, too, easily and quickly.

On the desired cell where the day, month or year should be, simply connect to the date cell.

Example: Click on cell C3 and enter "= A3" as the formula (without quotes).

The value (date) of cell A3 appears in cell C3.

Then on cell C3

press the right mouse button,

Format cells ... select,

go to Custom,

for type: insert DD for day, or MM for month, or YYYY for year.

Press Ok and you will only see the desired date, month or year.

Examples with this option and with formulas can be found in the inserted example file.

Hope I was able to help you with this info.

Nikolino

I know I don't know anything (Socrates)