Count Unique Days Of an Item Between 2 dates which is larger than 1

[Arturs]

Hello,

I have been trying to figure out a formula to see which materials are missing in the production for more than 1 day.

I have a 3 column report which I get sent every month - Start date, End date and Item Nr. (sheet1, columns A, B and C). I have formatted to short date columns A and B, but they do have time included as well.

In sheet2 I have created a Table :

Column A "Item Numbers" where I have removed all duplicates for Item Nr. from sheet 1
Column B - Date beginning 2021.01.01

I have been asked to try to create a report, where I can see how many unique days, an Item has been missing every month.
A missing item in production does not count as missing, if it is missing for one day (less than 24hrs).

In my previous attempt I created a column which had a number of days missing, but I could only manage to sum up the total amount of days per month. Could not find the formula to calculate unique days.

Ideally, in sheet2 cell B2 I would like to have 12 days.

Hope you can help, as I`m stuck for a couple days now

 

[jasonb75]

I'm running out of ideas.

Try clearing the formulas from the source table and re-entering them (Duration, Adjusted Start and Adjusted End columns). Although unlikely, it could be that one, or more of them is looking at the wrong column with the additional columns.

 

[Arturs]

I'm running out of ideas.

Try clearing the formulas from the source table and re-entering them (Duration, Adjusted Start and Adjusted End columns). Although unlikely, it could be that one, or more of them is looking at the wrong column with the additional columns.

Thank you , Jason!

I`ve used the =clean formula on duratation and added another column, looks like that was the case.

Sorry to reply this late, you helped me out a lot!