How to use Persian Dates in Excel?

In persian calendar first half of year (month 1-6) has 31 days and the next half (month 6-12) has 31 days.

I want to fill a cell with a date and add days to it ( for example 2000/01/26 + 6 days (in persian calendar) = 2000/02/1)

can some one help me?

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Answer

I would do the math with Julian dates and then convert to Persian. See:

GSNU2020

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer

Hamid,

__________________

Regards, Tom

1 person found this reply helpful

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Replies (2)

Last updated April 25, 2024 Views 13,542 Applies to: