Show MS–Excel Date as per local calendar

[mdee]

Do you know MS-Excel can translate Gregorian date into local calendar (of preference) date:



Steps:

Start Microsoft Excel
Enter today’s date in cell A1
Convert date as per Buddhist Calendar:

Move onto cell B1 and type = A1
Be on cell B1, move cursor onto Format Cell
Choose Category: as Date
Choose Locale (Location): as Thai
Choose date format in Type:
Cell B1 show date with Buddha-warsha



Convert date as per Islamic Calendar:




Move onto cell C1 and type = A1
Be on cell C1, move cursor onto Format Cell
Choose Category: as Date
Choose Locale (Location): as Arabic (UAE) or any Arabic
Choose date format in Type:
Cell C1 show date as per Hegira calendar



Convert date as per Tamil Calendar:




Move onto cell D1 and type = A1
Be on cell-D1, move cursor onto Format Cell
Choose Category: as Date
Choose Locale (Location): as Tamil
Choose date format in Type:
Cell D1 show date as per Tamilian calendar