Click on 1 cell and another cell change with same click

[malikumair56]

HI Guys, i am creating a calender template that will highlight dates from the deadlines task as they ae due in 1 month. I have a deadline tasks list which filters the data for that specific date in "L2" with the tast list.
I personally dont want to use VBA but if i have too can somebody please help with VBA.
Two questions
1- i have cells highlighted in the monthly calender with the deadlines dates set. If i click on any of the highligted cell in the calender, i want the date in L2 to be changed to that clicked cell. (Filter formula is in L3 which spits out the deadline task from the list
2. i have used sumproduct formula to highlight cells that are due from the list, but as you can see in Jul Monday, Tuesday and Wednesday are highlights when they shouldn't be as July month's start from Thursday (But as Jun 28 and 29 is in the deadline list thats why they highlighted too

 

[malikumair56]

VBA is sorted if anybody can help on the second point

below VBA helped solved first point

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("A3:G16")) Is Nothing Then
Call ShowHighlight
Else
Call ShowA3
End If
End If
End Sub

Private Sub ShowHighlight()
Range("L2").Value = ActiveCell.Value
End Sub

Private Sub ShowA3()
Range("L2").Value = Range("A3").Value
End Sub

 

[Snakehips]

@malikumair56
I do not have sufficient appreciation of what you are currently doing to provide a specific answer.
However, is it not just a case of adding to the conditions to test that the Month cells, July in this example, hold a value?
If cell is blank, ie does not hold a day number, represents the tail end of the previous month, then it fails the CF test irrespective of its inclusion in the list.

 

[malikumair56]

All sorted, i have figured and fixed on my own
Thanks All