Some notes from this question:
http://www.eileenslounge.com/viewtop...281312#p281312
Yasser Question.JPG

Question …
http://www.eileenslounge.com/viewtopic.php?f=30&t=36224

_____ Workbook: Extract missing dates for each person.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I T U V
1 Name Dates Helper Check Dates Result aa Yasser Given
2 aa 2021-02-19 2021-02-19 2021-01-26 2021-01-26 2021-01-29 2021-01-29
3 aa 2021-01-26 2021-01-26 2021-01-27 2021-01-27 2021-01-30 2021-01-30
4 aa 2021-01-27 2021-01-27 2021-01-28 2021-01-28 2021-02-05 2021-02-05
5 aa 2021-01-28 2021-01-28 2021-01-29 Missing 2021-02-12 2021-02-12
6 aa 2021-01-31 2021-01-31 2021-01-30 Missing
7 aa 2021-02-01 2021-02-01 2021-01-31 2021-01-31
8 aa 2021-02-02 2021-02-02 2021-02-01 2021-02-01
9 aa 2021-02-03 2021-02-03 2021-02-02 2021-02-02
10 aa 2021-02-04 2021-02-04 2021-02-03 2021-02-03
11 aa 2021-02-06 2021-02-06 2021-02-04 2021-02-04
12 aa 2021-02-07 2021-02-07 2021-02-05 Missing
13 aa 2021-02-08 2021-02-08 2021-02-06 2021-02-06
14 aa 2021-02-09 2021-02-09 2021-02-07 2021-02-07
15 aa 2021-02-10 2021-02-10 2021-02-08 2021-02-08
16 aa 2021-02-11 2021-02-11 2021-02-09 2021-02-09
17 aa 2021-02-13 2021-02-13 2021-02-10 2021-02-10
18 aa 2021-02-14 2021-02-14 2021-02-11 2021-02-11
19 aa 2021-02-15 2021-02-15 2021-02-12 Missing
20 aa 2021-02-16 2021-02-16 2021-02-13 2021-02-13
21 aa 2021-02-17 2021-02-17 2021-02-14 2021-02-14
22 aa 2021-02-18 2021-02-18 2021-02-15 2021-02-15
23 aa 2021-02-20 2021-02-20 2021-02-16 2021-02-16
24 aa 2021-02-21 2021-02-21 2021-02-17 2021-02-17
25 aa 2021-02-22 2021-02-22 2021-02-18 2021-02-18
26 aa 2021-02-23 2021-02-23 2021-02-19 2021-02-19
27 aa 2021-02-24 2021-02-24 2021-02-20 2021-02-20
28 aa 2021-02-25 2021-02-25 2021-02-21 2021-02-21
29 bb 2021-01-27 2021-01-27 2021-02-22 2021-02-22
30 bb 2021-01-28 2021-01-28 2021-02-23 2021-02-23
31 bb 2021-01-31 2021-01-31 2021-02-24 2021-02-24
32 bb 2021-02-01 2021-02-01 2021-02-25 2021-02-25
33 bb 2021-02-03 2021-02-03
Worksheet: Sheet1