Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to breakdown an Excel sheet by having it in a specific format. Right now, the sheet is like this

FROM           TO     TOTAL
01/27/12    01/27/12    1
03/09/12    03/09/12    1
04/11/12    04/13/12    3
12/24/12    01/04/13    7
06/04/12    06/13/12    8

I want to have Excel break down the dates on a row by row basis excluding Saturdays and Sundays. Example: 04/11/12 to 04/13/12. 3 days total should become


Any means of how to achieve this?

share|improve this question
Have you imported the data with space as the delimiter? – CodeBlend May 2 '13 at 10:59
To help improve your question, can you tell us what you have tried? – CharlieRB May 2 '13 at 11:50
Your 12/24/12 -> 01/04/13 = 7 example works only if you exclude holidays as well as weekends. That probably makes the question harder. – Scott May 2 '13 at 18:21

Slightly manual process would be to insert the number of rows you want. Then select the starting date and swipe down and highlight those new rows. Using the Fill -> Series dialog (in the Editing panel on the Home tab) you can fill in the dates with Sat and Sun skipped (just select Date and Weekday)


share|improve this answer
You can get a pop-up menu that gives you similar capabilities if you “swipe”/drag with the right mouse button. – Scott May 2 '13 at 18:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.