malikumair56
New Member
- Joined
- Jan 22, 2021
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
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
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