Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Dates
You might? like this idea
in cell g12 enter ctrl+: (control key and colon key) in h12 enter =text(g12,"dddd") -- Don Guillett SalesAid Software "Daviv" wrote in message ... I want to create a listbox for dates. For example, if I want to enter today's date 12/27/06, I could scroll to 12/27/06 in the listbox. Also, I want to have the day corresponding to the date that I choose to be input in another cell. So Thursday would show up in another cell. -- Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using automatic dates in cells | Excel Worksheet Functions | |||
automatic dates | New Users to Excel | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
Help with automatic dates | New Users to Excel | |||
Automatic Dates | Excel Programming |