i have a cell that is date of birth (DOB) format mm/dd/yyyy displays as dd-mon-yyyy
then i have a cell next to it that calculates age
i want the age cell to be highlighted if the birth day is after July 31
year does not matter month and day do
excel version 2010
please help.
Bookmarks