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?
Hi Mohammad, thanks for the reply.
Apologises if I did not express my self properly.
As 31JAN19 does exist in reality, I would consider it as a missing date considering the data I have been provided.
Edit: Exactly as Sergei said
Jamil, I guess these are all days in Jan 2019 which are not in ranges
