Tarikh Shamsi B Miladi !!link!!

For a quick, one-off conversion, the most reliable tools are:

: 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) tarikh shamsi b miladi