Hi

We use the following date format on our school timetable

6月15日 星期一 Mon Jun 15th

It has to be done manually every month which is a bit time consuming and can also lend itself to errors being made.

We are trying to find a way to get the dates to be automatically input into the table somehow.

I have found the "format cells/custom" but I am unsure how to use it. I have searched around on the internet for ages but have hit a brick wall trying to find any advice that includes Chinese dates.

The date we use is 6月15日 星期一 Mon Jun 15th. Which is when translated 6月 (June) 15日 (15th) 星期一(Monday) and then the English - Mon Jun 15th

Excel does have the option for Chinese style dates, but I don't understand how to make it use them in a way that we want.

We want the dates from Monday to Friday, no weekends as shown in the attached spreadsheet.

Blank.xls

Thank you for any help!