How to get the business days between today and target date

How to get the business days between today and target date

I have a table [Calendar], with columns Calendar Date and Business Day (1 represents a working day, 0 represents a holiday). Now, I have another table [aaa_file] with the column Target Date. How can I calculate the number of working days from today to the Target Date in the [aaa_file] table?

I try the query table, but it can't use "Today"
  2. SELECT 
  3.     a.Target_Date,
  4.     COUNT(c.Calendar_Date) AS Workdays_Count
  5. FROM 
  6.     aaa_file a
  7. JOIN 
  8.     Calendar c ON c.Calendar_Date BETWEEN Today AND a.Target_Date
  9. WHERE 
  10.     c.Business_Day = 1
  11. GROUP BY 
  12.     a.Target_Date