LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John in Surrey
 
Posts: n/a
Default populating a list box with weekly dates

Hi folks
I have half solved my wish to populate a list box with dates for the
next 5 sundays

I could create a list of dates in a column, name it and use data
valadation to craeate a drop down list of dates.
How do I make the first cell in the list = next sunday eg 30/10/05?

thanks john

listbox data
Next-sunday
next-sunday+7
etc
etc

john
Images of home (NZ)
http:\\www.myplace.co.nz/home
What we are up to in the UK
http:\\www.myplace.co.nz
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
How do I sort a list of dates in Excel by month and day? Caroline Excel Discussion (Misc queries) 3 June 10th 05 11:58 PM
Sumproduct and list of dates Ajay Excel Discussion (Misc queries) 4 May 18th 05 09:55 AM
Link a list of employees with hire dates to a monthly schedule lisabrmr Excel Worksheet Functions 0 May 17th 05 08:16 PM
FILTER OUT DATES IN LIST Lisa Excel Worksheet Functions 1 January 31st 05 02:17 PM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"