ExcelBanter

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

JonathanK1
Active Calendar
 
OK, I know how to put a calendar in a cell in Excel 2010 (add in, picker etc.). However, the dates I'm inputting are being pulled from a table and the data needs to be calculated (Sum/index/match function below the dates). So the dates need to be active. I have no clue if I'm using the right lingo...but I hope so.

Unfortunately, when I use the add in and put the date in there, the forumula below no loger works (the cell behind the calendar is still blank). Is there any way around this? Can't the cell recognize the date that is being entered?

I searched the forums first for this, but all I saw was how to get the calendar...which isn't enough. Sorry guys/gals. I appreciate your help!

J-

Spencer101
Quote:
Originally Posted by JonathanK1 (Post 1607796)
OK, I know how to put a calendar in a cell in Excel 2010 (add in, picker etc.). However, the dates I'm inputting are being pulled from a table and the data needs to be calculated (Sum/index/match function below the dates). So the dates need to be active. I have no clue if I'm using the right lingo...but I hope so.

Unfortunately, when I use the add in and put the date in there, the forumula below no loger works (the cell behind the calendar is still blank). Is there any way around this? Can't the cell recognize the date that is being entered?

I searched the forums first for this, but all I saw was how to get the calendar...which isn't enough. Sorry guys/gals. I appreciate your help!

J-
Could you post an example worksheet showing what you have so far?


All times are GMT +1. The time now is 12:53 PM.

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