Each name in sheet 1 column A has 10 identical names but different dates associated with those names in chronological order . Number of names will vary up to 2000 rows. Those dates are in column K with “year, month, day” format. Need a macro that will compare A) the number of days between the last 2 dates showing (per entry set of 10). Subtract. Then compare B) the last date showing (per entry set of 10) and today’s date. Subtract. If A => 24 days and B <= 23 days then in sheet 2 column N it should say a “Y” to the corresponding name. Else “N”.
If there are no dates for any or all the parameters required then an “N” will do. The sample workbook shows what I mean but the “Y” and “N” are not accurate for the date parameters. They are just for illustrative purposes.
Bookmarks