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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…