Thread
:
Automatic Dates
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett