Column A3:A13 each cell has a date in it. Column B3:B13 has someones name in each cell. At B16:B26 I want it to validate each entry in column B3:B13 and if the adjacent date in column A3:A13 is later than todays system date then I want it to count the name in column B. The objective is to list everyones name in column A16:A26 and list in column B16:B26 a counting of how many times their name appeared in B3 thru B13 but only if the date has already gone by. I can't figure out what to put in each cell at B16:B26 to make it evaluate the date and count the B3:B13 cells. Does anyone know how I can do that?
Bookmarks