missing Date Finder

[JG805]

Hello is there a formula or a VBA code to find the missing Date. i have a column that i need to review every month to identify the dates that are missing. example is below. if the column was small as bellow i can identify that i am missing
12/3, 12,4--12/8 712,9. THANK YOU IN ADVANCE




[TABLE="width: 75"]
<tbody>[TR]
[TD] Date[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/1/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/2/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/2/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/2/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/2/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/5/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/6/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/7/2018[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2018[/TD]
[/TR]
</tbody>[/TABLE]


JG805

 

[James006]

Hi,

See following link for VBA solution :

https://www.myonlinetraininghub.com/finding-missing-numbers-in-a-range-using-vba


Hope this will help

 

[Aladin Akyurek]

Control+shift+enter, not just enter, and copy down:

=IFERROR(SMALL(IF(ISNA(MATCH(ROW(INDIRECT(MIN($A$2:$A$11)&":"&MAX($A$2:$A$11))),$A$2:$A$11,0)),ROW(INDIRECT(MIN($A$2:$A$11)&":"&MAX($A$2:$A$11)))),ROWS($1:1)),"")

 

[JG805]

thank you so much Aladin Akyurek this is exactly what i was looking for. thank you for your help.

JG805

 

[Aladin Akyurek]

thank you so much Aladin Akyurek this is exactly what i was looking for. thank you for your help.

JG805

You are welcome.