Auto fill dates with both Chinese format and English format ie 6月15日 星期一 Mon Jun 15th

Perhaps something like this? pls see the file attach............

Im adding helper columns (on Sheet1) for the date, so you can change it later if you want.....

hope this works......

Hi azumi

That is amazing!

I can't even begin to thank you enough. But I will try, thank you!

I have no idea how you have done that, the formula crosses two monitors and is still going! Incredible work

How can I add in another week? What is the information in the formula that needs to be changed?

We sometimes have months that last 5 weeks - what needs to be changed please?

I have tried playing around with the formula but I just get errors.

Regards

May I have a copy of the working worksheet? I am very interested to learn this technique. Many thanks