How can i use Persian date (Shamsi) in excel 2007?

问题:

I,d like to use Persian date (Hijri- Shamsi) in excel 2007 worksheet directly as the base of calculation.but dont know how?

回答1:

I would convert the Persian dates to Julian dates via VBA , perform the calculations with standard Excel functions and then convert them back to Persian with VBA

I posted a reference here