ExcelBanter - How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac. (https://www.excelbanter.com/excel-worksheet-functions/27398-how-do-i-insert-sunday-monday-tuesday-etc-repeat-nonadjac.html)

novice user0879

How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac.

I need to repeat Sunday, Monday, etc. all through a worksheet in nonadjacent
cells. What is the formula that works for text and not date values?

All times are GMT +1. The time now is 05:25 AM.