Computer Hope
Software => Computer software => Topic started by: Spoiler on December 14, 2012, 10:10:41 AM
-
Hi All,
I am updating a old spreadsheet and wanted to add some work days down the side of it. The problem I have is that I only want Mon-Friday dates to be listed. For example....
12/3/2012
12/4/2012
12/5/2012
12/6/2012
12/7/2012
12/10/2012
etc.....
For some reason I can't get it to work right. In this example you can see that the first work day for Dec is the 3rd and that the 8th and 9th are passed over because they are a weekend.
I know I have done this before I just can't remember how I did it. I was able to click on a cell and drag down to highlite a months worth of cells and put in a formaula in the first cell and then all the dates would just show up below it.
Anyone have any ideas?
Thanks
Spoiler
-
I know I have done this before I just can't remember how I did it. I was able to click on a cell and drag down to highlite a months worth of cells and put in a formaula in the first cell and then all the dates would just show up below it.
Are dates for all rows part of the existing data?
If so, then one approach might be to add a column to show the day of the week and then use a Filter to show all days except Saturday and Sunday.
-
One option is, with a start date in A1, enter =WEEKDAY(A1,1) in B1, and copy it down.
-
soybean
All the dates are is a list. They don't come from any other data. I am using it just to keep track of the days work.
May this snippet will help explan.
[year+ old attachment deleted by admin]
-
So, somehow, you entered a formula in the top cell of a range and then dragged the content of that cell down to numerous rows below it and the dates filled in those cells but this did not include weekends. Is that right? To reiterate, you did not simply enter the date in the first/top cell, you entered a formula which skipped Saturdays and Sundays. Am I right so far?
-
I think you are on the right track. At this point all I am interested in is to list the weekdays. How its done really isn't that important.
-
this functionality appears to be built into Excel.
Put the start date in a cell.
Grab the Fill Handle (it's a small black box in the bottom right of the cell) and drag it down as far as desired. When you release, a small toolbox button should appear, titled "Autofill options". Expand this, and you can select a "Fill weekdays" option, which will exclude weekends.