Counting number of inspections using dates

[FILIPKACZMAR]

Hello,

I have a sharepoint file with a list of inspections made for my company. I have columns there with a date of inspection and date of delivered report (from the inspection).

I want to count how many inspections have report delivered in less than 5 days. 

Can you help me? Thank you

Thank you 🙂 

[helpme · Accepted solution]

Hi,

I would break the problem down into 2 steps.

1) Create a column with the difference between the two dates. Something like:

date difference = DATEDIFF(<Date1>, <Date2>)  

2) Next, create another column, [Difference of less than 5 days], that says

Difference of less than 5 days = if( [date difference] < 5, "Yes","No")

 (note that you can change the Y/N to boolean instead)

then in a table visualisation, you can add [Difference of less than 5 days] twice and change the setting of one of them to "Count of"

[FILIPKACZMAR]

Thank you!