Show reconciliation due dates by working day of the month

Summary:

Is there a way to see (in report or view) the reconciliations' due dates by working day (e.g., what is due on working day 1, working day 2, etc.)

Users would want to see a report/dashbord where for the current month they can see: reconciliations that need to be completed in Day1 of the month, Day 2 etc…. .

Content (please ensure you mask any confidential information):

I created a calculated attribute called DueDateWorkingDayInMonth of type integer, with the following formulae:

DATE_DIFF( DATE(YEAR( {End Date} ), MONTH( {End Date} ), 1) , {End Date} , 'DAYS') + 1

Users can use this attribute in the reconciliations list for a sort ascending .