ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Choosing a date (https://www.excelbanter.com/excel-worksheet-functions/15417-choosing-date.html)

Dawn

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


galimi

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



Bob Phillips

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