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 |
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 |
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 |
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 . |
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 . |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com