How to enumerate dates into a Google Sheets' column?

Question

I need to enumerate a Google Sheets' column with consecutive business dates (Sunday-Thursday) starting and ending with specific days.

Can this be done automatically or I have to this manually?

Answer 1

Manual way:

Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

Automatic way:

2.7
3.7
4.7
5.7
6.7
7.7
8.7

• enter dates in cells
• select all cells
• go to: Format > Number > More Formats > More date and time formats...
• delete: .Month (8)
• hit those arrows next to Day (5)
• from dropdown menu select: Day as full name (Tuesday)
• press Apply button and you are done