Detecting missing dates....

  • Thread starter Thread starter xDeniumx
  • Start date Start date
X

xDeniumx

5/7/04 16:03 Roger
5/10/04 9:02 Roger
5/10/04 15:59 Roger
5/11/04 8:57 Roger
5/11/04 15:59 Roger
5/12/04 9:06 Roger
5/12/04 15:59 Roger
5/14/04 8:19 Roger
5/14/04 16:30 Roger
5/16/04 9:27 Roger
5/16/04 16:12 Roger
Click to expand...


Above is part of a list of time and dates at which Roger went to a
office. Is there a way to detect / find out on which day, Roger didn'
go to the office? As u can see, 5/13/04 and 5/15/04 are missing, becaus
he didn't use his attendance card.....So how do I find out on whic
dates he was absent using Excel
 
One way:

In an unused column, say, column C, enter

=IF((A2-A1)>1,"Missed " & TEXT(A1+1,"mm/dd/yy") & IF((A2-A1)>2," - " &
TEXT(A2-1,"mm/dd/yy"),""),"")

Which will produce
C
1 Missed 05/08/04 - 05/09/04
2
3
4
5
6
7 Missed 05/13/04
8
9 Missed 05/15/04
 
Back
Top