Need to calculate ageing days for ticket opened till today , excluding weekends

[FaisalImam]

I tried this query and it was working fine , but today it is showing error.I think some exceptional cases, Please help to modify

Ageing Days = COUNTROWS(

FILTER(

ADDCOLUMNS(

CALENDAR(Incident[OPENED] ,TODAY()), "day of week" , WEEKDAY([Date],2)), [day of week] < 6 ))

Error : The start date in Calendar function can not be later than the end date.

[Greg_Deckler · Accepted solution]

@FaisalImam The problem is that somebody must have entered a OPENED date that is in the future. Perhaps put a check in IF the OPENED > TODAY() then BLANK, otherwise, the rest of your code.