Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
populating a list box with weekly dates
Hi!
How do I make the first cell in the list = next sunday eg 30/10/05? 10/30/2005 is THIS Sunday! The general formula to get the date for Sunday of the current week is: =TODAY()-WEEKDAY(TODAY(),2)+7 To increment this in steps of one week: =TODAY()-WEEKDAY(TODAY(),2)+ROWS($1:1)*7 Copy down as needed. Biff "John in Surrey" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
Sumproduct and list of dates | Excel Discussion (Misc queries) | |||
Link a list of employees with hire dates to a monthly schedule | Excel Worksheet Functions | |||
FILTER OUT DATES IN LIST | Excel Worksheet Functions |