Date list excluding weekends
in [General]
|
From: Connie Martin on 4 Jan 2010 11:48 If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a way to delete all weekends without the long, manual way of doing it? Connie
From: Harald Staff on 4 Jan 2010 11:56 Use the WEEKDAY formula to spot saturdays and sundays. Then use filter/autofilter to hide them, copy visible cells to another location. HTH. Best wishes Harald "Connie Martin" <ConnieMartin(a)discussions.microsoft.com> wrote in message news:7A8AFA01-2C11-4AD4-9803-EA101041FCBF(a)microsoft.com... > If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a > way > to delete all weekends without the long, manual way of doing it? Connie
From: "David Biddulph" groups [at] on 4 Jan 2010 12:03 Use a helper column =LEFT(TEXT(A1,"ddd")) Data/ Autofilter to select those where the entry is S Select those rows, and Delete row Disable the Autofilter, & delete the helper column. -- David Biddulph "Connie Martin" <ConnieMartin(a)discussions.microsoft.com> wrote in message news:7A8AFA01-2C11-4AD4-9803-EA101041FCBF(a)microsoft.com... > If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a > way > to delete all weekends without the long, manual way of doing it? Connie
From: Dave Peterson on 4 Jan 2010 12:03 You could use a helper column and return the weekday for that date: =WEEKDAY(a1,2) Then drag this formula down the column. Apply Data|filter|autofilter to this helper column and show the values > 5 (6 and 7 will be the weekends) Then delete the visible rows And remove the filter. ================ But maybe even better is to create the list without the weekends. Put the start date in A1 (say) Rightclick on the autofill button (the bottom right corner of the selection indicator. And drag down But choose "Fill Weekdays" There are lots of options you can get when you rightclick and drag on that autofill button. Connie Martin wrote: > > If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a way > to delete all weekends without the long, manual way of doing it? Connie -- Dave Peterson
From: Fred Smith on 4 Jan 2010 12:07
One option is to create the column without weekends, using a formula like: =if(weekday(a1)>5,a1+3,a1+1) Copy down Regards, Fred "Connie Martin" <ConnieMartin(a)discussions.microsoft.com> wrote in message news:7A8AFA01-2C11-4AD4-9803-EA101041FCBF(a)microsoft.com... > If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a > way > to delete all weekends without the long, manual way of doing it? Connie |