Business Days Formula- Question
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Community
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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