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......