changeable date from tab one auto mark on a calendar in tab 2

Good Morning,

I've been trying to find a way to for Excel to automate changes made on placed in service dates on a calendar for an easy look. Our placed in Service dates effect an abundance of department's workloads and I am hoping to create a better way for everyone to track changes. Is this possible? Please see attached example.

If I change the date in F2 from 5/30/21 to 6/30/21, I would like for it to reflect that change on the calendar on tab 2, moving the numerical value of 36 from G4 to H4.

Thank you!

I did a few changes so the following formula can be used:

in C4

=IF(TEXT(BLD!$F2,"mmm")=C$2,INDEX(BLD!$G2:$G$100,MATCH($B4,BLD!$A$2:$A$100,0)),"")

Months in row 2 all 3 characters.

Data in column B needs to match that in A in "BLD"

Great! Exactly what I was looking for, thank you so much!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thanks for your help, I will solve it now. I did add to your reputation already