Forum Discussion
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 missing days:
- 21JAN19
- 22JAN19
- 23JAN19
- 31JAN19
Do you have any advice on how to build it?
Thank you very much in advance for the help
Please see attached workbook that i have embedded the formula.
8 Replies
- JamilBronze Contributor
- Marco VeraceCopper Contributor
Thank you very much!
Absolutely what I needed!
- JamilBronze ContributorYou are welcome.
Another question how many such ranges could be (here we have two)
- Marco VeraceCopper Contributor
I have two ranges each time, but different example to analyse.
Thanks,
Marco
- JamilBronze Contributor
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?
- Marco VeraceCopper Contributor
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