Formatting and Counting Dates Occurring Before or After a Specified Date

[@abigaellapid97]

Hello, this is very helpful. What is the purpose of the $ sign in 6:56 for counting dates?

[@diane3460]

Is this just for our knowledge, or is this something that may be needed as part of our research.

[@alokghosh9311]

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.

[@inouterspace1]

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?

[@darsynm]

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

[@Berghiker]

How do I add up only current working days in a month?

[@robertwofford5324]

this highlights also blank cells for me

[@moosethepensioner]

thanks

[@DrGrande]

You're welcome -

[@akshayamberkar3970]

How I can find before date and after date of a given particular date ??
Please help me out

[@AnkushSharma-zv5hv]

helpful

[@DrGrande]

Thanks -