Forum Discussion

ScottGraham's avatar
ScottGraham
Qrew Trainee
8 years ago

I need a formula to Subtract Today from a date and return the difference in weekdays only if another field is blank

I need a formula to Subtract Today from a date and return the difference in weekdays only if another date field is blank. So basically I want to know how many days late an order is if it hasn't shippe...
ScottGraham's avatar
ScottGraham
Qrew Trainee
8 years ago
Thank you for the help. I am getting the following error.
The types of the arguments or the number of arguments supplied do not meet the requirements of the function ToDate.

The function ToDate can be used with the following arguments:
  • ToDate (Text x).
  • ToDate (Text x, Text f).
  • ToDate (Date/Time x).