Drop down box date choice 1

[APierce1]

Background: we're using Excel 2002 to create a spreadsheet to list on-call personnel, week by week. This spreadsheet will be updated/changed on a daily basis.

That said, does anyone know of a way to create a drop down box that would allow a user to pick a date always starting with todays date and going into the future? The spreadsheet came to me with a hidden worksheet with a long list (2003 and 2004) of dates that are inserted into a drop-down box. As you can imagine, it gets a bit tedious to pick a date as days go by.

Any help would be greatly appreciated.

Best regards,
Alan
Ithaca, NY

 

[bluedragon2]

Depending how far in the future you want, one way is to have a set of cells like:

a1 - =now()
a2 - =now()+1
a3 - =now()+2

and so on for as many dates you want in the drop down list. Then link your box to that range.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[APierce1]

I tested to make sure it would hold the correct entry when the date changes, and it worked like a charm.

Thanks BlueDragon!

Alan

 

[xlbo]

Sounds like a helpful AND expert post. APierce1 - the stnadard way to say thanks in TT is to award a star. This also means that those users who search the archives can more quickly find those answers that provide useful info. To award a star, simply click on the "Mark this post as a helpful/expert post" link at the bottom of the appropriate thread

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[APierce1]

Thanks, Geoff, for the ettiquette lesson. I have, indeed, awarded BlueDragon a star as his reply was exactly the help I needed and a very quick responce.

Thanks again, BlueDragon!

Best regards,
Alan

 

[xlbo]

Excellent resolution all round then

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[APierce1]

Houston, we have a problem. Every day, when the spreadsheet is opened, the date changes in every field to today's date. Not quite what I had hoped for. ;^)

Any other thoughts?

Best regards,
Alan

 

[xlbo]

Bizarre
=Now() should produce todays date
=Now()+1 should ALWAYS produce that date after today

I really don't understand what could go wrong with that....
You could email me the spreadhseet
geoff.barraclough at punchpubs.co.uk
and I'll take a look.....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244