Only show weekdays of a month

[Anarchus]

Hi there,

This is probably a simple one but having complete mind blank.

In cell E10, I have the first day of the month, which will change each month of course.

In cell E11 and continued down, I would like the working days of the month to appear in the cells below it, what function is needed to do this?

i.e
January 2017
E10 = Sunday 1st January 2017
E11 = Monday 2nd January 2017
E12 = Tuesday 3rd January 2017
E13 = Wednesday 4th January 2017
E14 = Thursday 5th January 2017
E15 = Friday 6th January 2017
E16 = Monday 9th January 2017

February 2017
E10 = Wednesday 1st February 2017
E11 = Wednesday 1st February 2017
E12 = Thursday 2nd February 2017
E13 = Friday 3rd February 2017
E14 = Monday 5th February 2017
E15 = Tuesday 6th February 2017
E16 = Wednesday 7th February 2017

[Logit]

Put this formula in E10 :

Please Login or Register  to view this content.

Put this formula in E11 and copy down:

Please Login or Register  to view this content.

Format column E10 and down as

Please Login or Register  to view this content.

[JBeaucaire]

Use the WORKDAYS function. It will only diplay dates that are Mon-Fri and also optionally are not listed in a range of listed holidays.

E10 - enter your starting date.
E11 =WORKDAY(E10, 1)

If your holidays were listed in column Z, then this would skip any dates listed there:

=WORKDAY(E10, 1, Z:Z)

[Anarchus]

Thanks Beaucaire, that's exactly what I needed!