Forum Discussion

Marco Verace's avatar
Marco Verace
Copper Contributor
May 30, 2018
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...
Formulas & Functions
Need Help days month formula
  • Jamil's avatar
    Jamil
    May 30, 2018

    Please see attached workbook that i have embedded the formula.

     

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 30, 2018

Another question how many such ranges could be (here we have two)

  • Marco Verace's avatar
    Marco Verace
    Copper Contributor
    May 30, 2018

    I have two ranges each time, but different example to analyse.

     

    Thanks,

    Marco

Resources