Dear Community,
I was using this formula without issues: BUSINESSDAYS([Date Requested], [Date Closed])
Now I am facing an error (argumnents must be strings...but I am comparing dates).
I've found tons of discussions and even a Challenge (Nª252), but the solutions there provided are quite more complicated...to calculate just network days...
Do you know if something has changed with the Business days formula?
Thanks for your support, I've been struggling with this hours.
Henry
Thank @binuacs for your fast response.
Let me give you more context:
I am comparing to date columns (i.e.)
Column A: 2021-11-26
Column B: 2022-01-03
Data type of both columns "Date"
If I use this formula: BUSINESSDAYS([Column A],[Column B]) It triggers following error: "Parse error at char(0):Argument 1 of date time diff is not a string".
Hope this give you more context.
Tks!
Henry