Finding missing dates with time in sequence

Hi All,

Please help!!!!!!

How to find Missing dates in sequence.

I have lot of dates along with time listed in excel, I wanted to find the missing times in excel.

Below is my format.

31/3/2014 05:30
31/3/2014 05:31
31/3/2014 05:32
31/3/2014 05:34
31/3/2014 05:36

On the above list i wanted to find the missing dates, i.e.,

31/3/2014 05:33
31/3/2014 05:35

Kindly help.

Try this:-
Results in column "B".

Please Login or Register  to view this content.

Regards Mick

Hi Mick,

Thank you so much for your reply. Really it helped me a lot.

Using your macro I've an excel file where in the first column (A) i've the original datas and in (B) the datas generated by using your macro which have all the original and missing datas.

Kindly help me to find out the missing numbers in column A which is present in column B.

I tried Vlookup it didnt helped me.

Thank you so much once again

Regards,
Yuvaraj

You're welcome

Mick please help me on the above post....

Try this example:-