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

Date

12/1/2018

12/1/2018

12/2/2018

12/2/2018

12/2/2018

12/2/2018

12/5/2018

12/6/2018

12/7/2018

12/10/2018

<tbody>
</tbody>

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.