Forum Discussion
Solved
Find missing days within a Range
Hi guys! I would need to know if some days are missing, see the example below please. I have a range of days like this : 01JAN19 - 20JAN19 24JAN19 - 30JAN19 I'd like to get an output of the...
Please see attached workbook that i have embedded the formula.
Your logic does not seem to be correct.
your range does not have 31 Jan 2019 then why to list 31JAN19 in the missing dates?
Jamil, I guess these are all days in Jan 2019 which are not in ranges