In Excel how to Generate Sequential Weekday names like Sun, Mon, Tue, .....,Sat.
For 3 characters Weekday name
- =TEXT(DATE(2024,1,SEQUENCE(7)),"ddd")
- =TEXT(DATE(2024,1,ROW($1:$7)),"ddd")
(Note – Year 2024 has been used as 1-Jan-2024 was Monday. You can use any year in place of 2024 where 1-Jan was a Monday like)
For full Weekday name, replace ddd with dddd
- =TEXT(DATE(2024,1,SEQUENCE(7)),"dddd")
- =TEXT(DATE(2024,1,ROW($1:$7)),"dddd")
You can add a number if you want to show some other Weekday Name. Say, if you want to show 1 = Monday, 2 = Tuesday…….7 = Sunday, just add 1 . Hence, formulas would become
- =TEXT(1+DATE(2024,1,SEQUENCE(7)),"ddd")
- =TEXT(1+DATE(2024,1,ROW($1:$7)),"ddd")
The above Excel formulas will generate the sequence in a column. If you want to generate in a row, use following formulas
- =TEXT(DATE(2017,1,SEQUENCE(,7)),"ddd")
- =TRANSPOSE(TEXT(DATE(2017,1,ROW($1:$7)),"ddd"))