Document Editing Problems

How to Convert Persian Dates to Gregorian Dates in Microsoft Word

John WilsonJohn Wilson Oct 20, 2026 868 views

Question details

The user needs to convert dates written in the Persian calendar to their Gregorian calendar equivalents within a document.

How to Convert Persian Dates to Gregorian Dates in Microsoft Word
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA Editor

In Microsoft Word, press 'Alt + F11' on your keyboard to launch the Microsoft Visual Basic for Applications window.

2
Insert a New Module

Click 'Insert' from the top menu and select 'Module' to open a new blank coding window.

3
Paste the Conversion Code

Copy your custom Persian-to-Gregorian VBA script and paste it into the new module window.

4
Run the Macro

Press 'F5' or click the green 'Run' button in the toolbar to execute the script and convert the dates across your document.

Use a VBA Macro to Automate Date Conversion
VBA Scripting Assistance: Writing or troubleshooting VBA code requires programming knowledge. If your script encounters errors, consider consulting Microsoft VBA support documentation or developer forums for specialized coding assistance.
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open Your Document: Launch WPS Writer and open your existing Word document to experience seamless compatibility.
  3. 3. Edit and Save: Format, edit, and save your document in standard formats without losing any layout settings.
Free and lightweight office suite with a fast installation processExcellent format compatibility with Microsoft Word (.docx, .doc, .docm)Supports VBA macros in professional versions for complex task automationFamiliar user interface requiring zero learning curve
microsoft office alternative - wps office

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.