Plot date in calendar

[Nicki]

Hi, Please could you check the error in counting the course name on " course summary" tab and conditional formatting to highlight the proposed date for Course Name on calendar in Blue. Many Thanks

 

[PaulF]

You are trying to SUM a text range... You need to count...
D26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$4)

 

[PaulF]

L26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$5)
T26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$6)
AA26 =COUNTIFS(tblCourse[Start Date],">="&DATE($AN$5,1,1),tblCourse[Coruse Type],Settings!$D$7)

 

[Nicki]

Many Thanks PaulF. it is working for counting the course type. but could you look the conditional formatting i.e. I want to have those three dated for CPD to be highlighted in blue on calendar as well. I appreciate it if you can help.

 

[deciog]

Nicki, Good Morning.

Checks whether Conditional formatting is correct for you

Decio

 

[Nicki]

Nicki, Good Morning.

Checks whether Conditional formatting is correct for you

Decio

Thanks so much deciog. great job

 

[Nicki]

Could you please help where I have gone wrong. Clicking on colored date on calendar, wont show up the details of the course on the right side of calendar. I'd like to select a cell (calendar date) and events on that day are shown next to the calendar on right. Many thanks for help

 

[PaulF]

You will require VBA to utilize a clicked cell to action. What have you tried so far?

 

[Nicki]

You will require VBA to utilize a clicked cell to action. What have you tried so far?

Hi Paul, I have used intersects but it is still does not work. see below

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B5:AQ20")) Is Nothing Then
Range("G2") = Target.Value
End If
End Sub