I have a spreadsheet that is used for monitoring birthdays for children that are under 2. I need to find a way to automatically highlight children who have a birthday falling in the current week's date range. For example, using the current week, M-F 02/24-02/28/14, I need all the children with birthdays this week that are turning one or two, so anyone with a 2012 or 2013 birthday from 02/24-02/28. Is there a formula or a conditional highlighting that I can use to avoid going row by row to monitor the birthdays?
Bookmarks