Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Choosing a date
Is there a way in Excel to fill a cell with a date by
choosing from some type of calendar setup? If you wanted to choose Jan 5 2005 you could click on a pop-up that would let you choose the 5th, or would this take more programming, than functions? Thanks |
#2
|
|||
|
|||
Dawn,
There is a Microsoft Calendar Control that can be embedded into Sheets and perform the way you desire with minimal code. http://HelpExcel.com "Dawn" wrote: Is there a way in Excel to fill a cell with a date by choosing from some type of calendar setup? If you wanted to choose Jan 5 2005 you could click on a pop-up that would let you choose the 5th, or would this take more programming, than functions? Thanks |
#3
|
|||
|
|||
See www.rondebruin.nl/calendar.htm
-- HTH RP (remove nothere from the email address if mailing direct) "Dawn" wrote in message ... Is there a way in Excel to fill a cell with a date by choosing from some type of calendar setup? If you wanted to choose Jan 5 2005 you could click on a pop-up that would let you choose the 5th, or would this take more programming, than functions? Thanks |
#4
|
|||
|
|||
Thanks I'll give it a try.
-----Original Message----- Dawn, There is a Microsoft Calendar Control that can be embedded into Sheets and perform the way you desire with minimal code. http://HelpExcel.com "Dawn" wrote: Is there a way in Excel to fill a cell with a date by choosing from some type of calendar setup? If you wanted to choose Jan 5 2005 you could click on a pop-up that would let you choose the 5th, or would this take more programming, than functions? Thanks . |
#5
|
|||
|
|||
Thanks I'll give it a try.
-----Original Message----- See www.rondebruin.nl/calendar.htm -- HTH RP (remove nothere from the email address if mailing direct) "Dawn" wrote in message ... Is there a way in Excel to fill a cell with a date by choosing from some type of calendar setup? If you wanted to choose Jan 5 2005 you could click on a pop-up that would let you choose the 5th, or would this take more programming, than functions? Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date and time | New Users to Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |