Hi FDibbins, Thanks for the help. Your solution is close, but the date is still not quite there. Your formula does flag anything that is for a caregiver, under 12 hours, and on the birthday of the current year. What I would like is for it to flag the cell if today is within 30 days of the birthday for the current year or past the birthday of the current year.