I have different dates in column A1 (1-Oct-19, 15-Oct-19,29-Oct-19, 12-Nov-19, 26-Nov-19 and so on). I want to highlight only the current month in green and the rest of the month in the red. I mean before and after Jan in the red and Jan (Current Month) in green.
When I do what the video does it highlights all of them, if I do "between" it highlights the dates after the specified date. Same with before or less then it highlights all of them. is there a reset or something I need to do?
Hello, wondering how i can instead of counting them by numbers, getting a percentage of how many before the date, and percentage of how many after the date
Hello, this is very helpful. What is the purpose of the $ sign in 6:56 for counting dates?
Is this just for our knowledge, or is this something that may be needed as part of our research.
I have different dates in column A1 (1-Oct-19, 15-Oct-19,29-Oct-19, 12-Nov-19, 26-Nov-19 and so on). I want to highlight only the current month in green and the rest of the month in the red. I mean before and after Jan in the red and Jan (Current Month) in green.
When I do what the video does it highlights all of them, if I do "between" it highlights the dates after the specified date. Same with before or less then it highlights all of them. is there a reset or something I need to do?
Hello, wondering how i can instead of counting them by numbers, getting a percentage of how many before the date, and percentage of how many after the date
How do I add up only current working days in a month?
this highlights also blank cells for me
thanks
You're welcome -
How I can find before date and after date of a given particular date ??
Please help me out
helpful
Thanks -