How do I fill weekdays including saturdays in a excel sheet? If I do fill weekdays while filling cells then both saturdays and sundays are excluded but I only want to exclude sundays.



How can I do that?

What do you mean by "fill weekdays"? Pulling a formula down?
If so, which formula is it?
Sample sheet eventually? ( no pics)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes I'm talking about pulling down a date in a cell like 1-Jan-2019 till 2-Feb-2019...and no special formula just writing a date in a cell and dragging it down or on the right side like below

Attached Images

	001.png (3.5 KB, 30 views)
	002.png (14.7 KB, 30 views)

No such option for pull-down (or List option) exists!

A workaround:
Add a column where weekday for date in same row is calculated;
Set Autofilter on for table, ant set the filter for added column so only Sundays are displayed;
Activate all displayed rows (NB! ROWS!), and delete them;
Remove filter, and delete the added column.

It's done!

Hi ArviLaanemets,

Can any function be used to do what I'm trying to achieve?

Attached is an example, with 2 formulas - one uses ISO week definition, another US week definition (and according WEEKDAY() function parameters). The result is same of-course.

The start date is Monday of week, where Start Date defined on Sheet SetUp belongs to.

Attached Files

DateList.xlsx (12.2 KB, 11 views)