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