Year Planner Display Date include formula

[Jaykill]

Hi

I am building a year planner to track the progress and milestones for cost saving projects.

I have one worksheet that contains all the milestones, due dates and the savings per month.

My question is:

Is it possible to build a calender where the cell displays the date (like a little number in the top right hand corner) but also has a formula so you can return the values associated with those milestones when they reach their due date on the year planner?

I will also be adding some conditional formating so that any cell less than today's date is shaded grey.

Any feedback, hints or ideas would be greatly appreciated.

Jaykill

 

[shemayisroel]

Hi,


Could you please post some sample data along with the expected results/outcome on how you would want the info displayed?