MS Excel date query

  ThePharcyde007 09:20 27 May 04
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 04

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 04

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 04

Thank you all

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

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

Hands-on: Acer Predator Triton 700 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017