Forum Discussion
Find missing dates
Good day to all members, I am struggling with dates. I attached a file for example. I need to find the missing dates between the dates & report them, Anyone can please suggest me a way to do it?
It depends on which Excel version/platform you are. If with supporting dynamic arrays that could be
=LET(
minDate, MIN( dates ),
maxDate, MAX( dates),
allDates, SEQUENCE( maxDate - minDate + 1, , minDate ),
FILTER( allDates, ISNA(XLOOKUP( allDates, dates, dates)))
)