• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Weekdays list

Y

Yulechka

New Member
Hello,

Excuse my not smart question here, but i need to figure out how to list only weekdays in date format. Basically, my column in the report should have only week days excluding Sat and Sun for 2015.
TIA!
 
Yulechka said:
Hello,

Excuse my not smart question here, but i need to figure out how to list only weekdays in date format. Basically, my column in the report should have only week days excluding Sat and Sun for 2015.
TIA!
Click to expand...
Hi,

Enter a date in a cell and select that date and as many blank cells as you want to fill then

Home tab | Editing group | Fill | Select 'Series' - 'Weekday' OK

or

Enter a date in your first cell and right click on the fill handle and drag when you release the right mouse button click weekday on the popup.
 
Last edited:
Or one more:
=WORKDAY(A2,1)
Dragged down, with A2 having a date, will generate a list of workdays.
 
You must log in or register to reply here.
Back
Top