I'm trying to enhance a calendar developed by some experts.
The calendar is working fine to populate the dates of a calendar month (based on value of A1)
But I need 2 enhancements (second one is optional):
1. I got a list of days in tab: Public Holidays. What I wish is to minus the working days calculated at column J
For example, currently cell: J8 is calculated = 5, but since 25 Dec is a public holiday, can this value be deducted to 4?
If this even possible, can we apply a Conditional Formatting to mark that cell with black background color?
2. As you can see the date "3" is selected with green background color, but since I had selected A1 = Dec 17 and it's actually not today (3 Nov 17)'s date, can the Conditional Formatting only applied when it's actual day (today), not based on month day?
Attached is what I currently have.