Quickly find missing dates from a list in Excel

preview_player
Показать описание
The video offers a short tutorial on how to quickly find the missing dates from a list in Excel.
Рекомендации по теме
Комментарии
Автор

Hello I have a data set of listed companies which is repeating yearly (each 16 years). Like 31-12-2000, 31-12-2001, 31-12-2002 31-12-2016 and then starts again for another listed company code from 21-12-2000. But for some companies some years are missing. How can I detect the missing years? Many thanks.

burakoktem
Автор

Very misleading and poorly tested. What if there are two consecutive dates missing?

schecter
Автор

Sir esi formulas ko Google sheet me nehi ho raha haa pls help me?

ranjitray
join shbcf.ru