MS Excel date query

  ThePharcyde007 09:20 27 May 2004
Locked

Guys - I need to do a date collumn which I want to do a list of dates 01 June 2004 - 2010, but! I do not want it to show saturdays, and sundays, as they are no working days. How would I do this?

  Jakey boy 09:57 27 May 2004

there are none of the Excel experts about, but I would suggest you click here
The best help you can get, believe me!

  tmr 10:14 27 May 2004

Enter the start date at top of column you want, select (highlight) the column including the start date field, go to edit, select fill, select series, in "series" select 'columns', in "type" select 'date', in "date unit" select 'weekday',
in "step value" enter '1'.
This will enter a series of dates only including weekdays but you will have to select (highlight)the required number of fields for the number of days in the required period.
Hope this helps.

  ThePharcyde007 11:30 27 May 2004

Thank you all

tmr your a star! Cheers buddy A* for you!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires