Active Calendar

[JonathanK1]

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

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

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

J

 

[Spencer101]

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

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

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

J-

Could you post an example worksheet showing what you have so far