How could I convert Shamsi date to Gregorian in Excel or Sheet?

Hi @raha azad

Welcome to Q&A forum ~

Are you using Microsoft 365 Apps or Excel 2021?

If so, please try the following Let formula which is created based on my simple sample. This formula will get a srting of number.

=LET(y,VALUE(LEFT(A1,4)),m,VALUE(MID(A1,6,2)),d,VALUE(RIGHT(A1,2)),full_months,IF((m-1)<7,(m-1)*31,IF((m-1)>6,(m-1)*30+6)),total,(y-1)*365+full_months+d+INT((y-1)/4),IF(MOD(y,4)=0,total+1,total)-466710)

Then convert the string of number to Gregorian in "yyyy-mm-dd" format. You may also try other formats of Gregorian.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.