In IDEA, To Filter out dates on which bills have not been raised with the facility to exclude weekends and holidays, we can use:

Gap Detection

Pivot Table

Sort

Group Records

Random sampling