I have a huge spreadsheet that contains patient visit dates spanning three years. The visits can range from weekly to monthly to quarterly. I have over two patients that start at different times during this time and I've used conditional formatting to highlight those visits who visit dates fall...
www.mrexcel.com