Pivot tables with multiple checks on one data set

[Eazygeezer]

Hi, Apologies but I couldn't find an answer to this so please forgive me if it has been answered elsewhere.

I am running a check on data from a scheduling team, their target is to book appointments at least 4 to 6 weeks in advance. I would like to display this data in a pivot table (if posslble) to show appointments booked more than 4 weeks, between 3 and 4 weeks, between 2 and 3 weeks and any booked under 2 weeks without counting any twice.

I have tried a multiple if, but the data doesn't seem to either filter or count correctly in the pivot table and I can't figure out why.

Is anyone able to help?

Thanks

[oeldere]

F2 =IF(D2<0,-MROUND(ABS(D2)/7,1),MROUND(ABS(D2)/7,1))

After that a pivot table.

See the attached file.