How to Convert Persian Dates to Gregorian Dates in Microsoft Word
Question details
The user needs to convert dates written in the Persian calendar to their Gregorian calendar equivalents within a document.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Editing a document that contains multiple Persian dates requiring standardization to the Gregorian calendar system.
- Observed behavior
- Microsoft Word lacks a built-in feature to automatically recognize and convert Persian calendar dates to Gregorian dates, requiring manual replacement or a programmatic workaround.
Because this solution requires running custom scripts, ensure your document is saved in a macro-enabled format (.docm) and create a backup copy of your file before executing any automated replacements.
Use a VBA Macro to Automate Date Conversion
Since Word does not have a native conversion feature, you can use a custom Visual Basic for Applications (VBA) script to scan for Persian dates, calculate their equivalents, and replace them automatically.
A VBA script can be programmed to identify specific Persian (Jalali) date patterns within your document text. Once identified, the code calculates the corresponding Gregorian date and executes a bulk replacement.
You will need a reliable conversion script, which can often be sourced from developer communities like Stack Overflow, as it involves specific calendar math algorithms.
In Microsoft Word, press 'Alt + F11' on your keyboard to launch the Microsoft Visual Basic for Applications window.
Click 'Insert' from the top menu and select 'Module' to open a new blank coding window.
Copy your custom Persian-to-Gregorian VBA script and paste it into the new module window.
Press 'F5' or click the green 'Run' button in the toolbar to execute the script and convert the dates across your document.

Experience Seamless Document Editing with WPS Office
While specific macro-based tasks depend on custom scripts, WPS Office provides a fast, lightweight, and highly compatible alternative to Microsoft Word for your daily document processing and formatting needs.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Document: Launch WPS Writer and open your existing Word document to experience seamless compatibility.
- 3. Edit and Save: Format, edit, and save your document in standard formats without losing any layout settings.

Frequently Asked Questions
Is there any built-in tool in Word to convert Persian dates?
No, Microsoft Word treats Persian dates as standard text and does not offer a native calendar conversion feature to translate them into Gregorian dates automatically.
Can I convert the dates using Excel instead?
Yes, if you have a structured list of dates, it may be easier to copy them into Excel, apply an Excel-specific date conversion formula or add-in, and then paste the converted Gregorian dates back into Word.
Will finding and replacing dates manually affect my document formatting?
Manual Find and Replace operations will generally preserve your surrounding text formatting, but doing this for a large volume of dates is time-consuming and prone to human error, which is why a VBA macro is recommended.




