ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calendar (https://www.excelbanter.com/excel-worksheet-functions/46551-calendar.html)

Phil Hageman

Calendar
 
I want to put future dates in various cells. Does Excel have a calendar
where future months can be selected, the date selected, and then have that
date entered into a cell? If not, does it have the calendar?

Thanks, Phil

Paul B

Phil, have a look here for a way to do it,

http://www.fontstuff.com/vba/vbatut07.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil Hageman" wrote in message
...
I want to put future dates in various cells. Does Excel have a calendar
where future months can be selected, the date selected, and then have that
date entered into a cell? If not, does it have the calendar?

Thanks, Phil




Ron de Bruin

See also this page ( the link Paul posted is also on this page)
http://www.rondebruin.nl/calendar.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Paul B" wrote in message ...
Phil, have a look here for a way to do it,

http://www.fontstuff.com/vba/vbatut07.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil Hageman" wrote in message ...
I want to put future dates in various cells. Does Excel have a calendar
where future months can be selected, the date selected, and then have that
date entered into a cell? If not, does it have the calendar?

Thanks, Phil






Phil Hageman

This is one of the best instructions I've ever seen written! These people
know how to bring an basic user through an otherwise complicated process.
Thanks for the tip.

"Paul B" wrote:

Phil, have a look here for a way to do it,

http://www.fontstuff.com/vba/vbatut07.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Phil Hageman" wrote in message
...
I want to put future dates in various cells. Does Excel have a calendar
where future months can be selected, the date selected, and then have that
date entered into a cell? If not, does it have the calendar?

Thanks, Phil






All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com