customize date excel 2013

[ghostanime2001]

Hello, I have class monday, tuesday, wednesday & friday but no class thursday. How can I make automatically fill in dates for weekdays only and skip thursday using excel 2013's "Fill" function then "series" ??

Thank you.

[BadlySpelledBuoy]

Is this question for "homework"?



http://www.excelforum.com/excel-form...-weekdays.html

[MarvinP]

Hi,

Perhaps you can use all dates and then filter them by only showing the days you want? See the attached for an example.

[ghostanime2001]

No this is not homework, this is for my personal organization so I can keep track of what classes were cancelled or missed or missed assignments etc... Is there no simple function that allows customization of what weekdays to omit and show ?

[ghostanime2001]

For example, here is my sample worksheet. I have created a list of dates from Jan 7 to Feb 10, 2014. I want all weekdays except thursday in that time period

example.xlsx

[MarvinP]

Did my answer get skipped? Does it work for you?

[ghostanime2001]

I don't understand your file. Thursdays are still showing.