Calculate Number of Business Days from Today
Summary
Calculate Number of Business Days from TodayContent
I have this formula and results returned "4".
I am trying to calculate the number of business days between the day the report is run and the CSW Current Status Start Date.
TIMESTAMPDIFF(sql_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, - DAYOFWEEK(MIN("Submission CSW Status - Current"."Current Status Start Date"))+2, MIN("Submission CSW Status - Current"."Current Status Start Date")), NOW())
I appreciate it if you can review the formula and let me know how to correct it?
Sincerely,
Anne Lee
0