Shamsi B Miladi __hot__ - Tarikh

In our daily lives, we often take for granted the way we measure time. We wake up every morning, check our clocks, and plan our days accordingly. But have you ever stopped to think about the calendar system we use? In many parts of the world, especially in Iran and Afghanistan, there are two widely used calendar systems: Tarikh Shamsi (Persian Solar Calendar) and Miladi (Gregorian Calendar). In this blog post, we'll explore the differences between these two calendars and their significance.

Converting a (Shamsi) date to a Gregorian (Miladi) date involves transitioning between two solar-based systems that use different starting points (epochs) and month structures. Understanding the Two Systems tarikh shamsi b miladi

The Shamsi year has 12 months, with the first six having 31 days and the next five having 30 days. The last month, Esfand, has 29 days (30 in leap years). Shamsi Month Gregorian Start (approx.) Ordibehesht September 23 October 23 November 22 December 22 January 21 February 20 4. Reliable Conversion Tools In our daily lives, we often take for

: You can use a LET function to parse the date string and calculate the difference. For example: =LET(y,VALUE(LEFT(A1,4)),m,VALUE(MID(A1,6,2)),d,VALUE(RIGHT(A1,2))...) 3. Programming & Developer Tools (Best for automation) In many parts of the world, especially in

Converting between these two systems generally follows a simple offset, but requires careful attention to the start of the solar year: Year Offset : To find the Gregorian year, you generally add (if the date is between Farvardin and Azar) or (if it is between Dey and Esfand) to the Shamsi year. The Pivot Point : The Solar Hijri year begins on the Vernal Equinox (usually March 20 or 21), which marks the first day of Month Structure