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

#### Arturs

##### New Member
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

##### Well-known Member
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.

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### Arturs

##### New Member
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!

Replies
7
Views
46
Replies
4
Views
143
Replies
6
Views
398
Replies
4
Views
324
Replies
1
Views
70

1,141,873
Messages
5,709,104
Members
421,614
Latest member
RAB29

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back