- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2023 10:32 AM
Hello all, I am trying to use the WORKDAY_DIFF Formula but it is returning #ERROR and I am struggling to determine why. The IF,AND piece is working, the WORKDAY_DIFF is not (on its own or with the rest of the formula).
IF(
AND({DateSubmitted}, {DateCompleted}),
WORKDAY_DIFF({DateSubmitted},{DateCompleted})
)
My fields are set to ISO dates. DateSubmitted is the Created Time auto value, and the DateCompleted is a formula -
IF(Status="Done",NOW())
Any help you can provide would be much appreciated. Thank you!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2023 12:55 PM
Good Afternoon @MegFox!
This would likely be an issue with time zone. In the Date Submitted Field and Date Completed Field check to make sure that you are using the same time zone.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2023 12:55 PM
Good Afternoon @MegFox!
This would likely be an issue with time zone. In the Date Submitted Field and Date Completed Field check to make sure that you are using the same time zone.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2023 02:18 PM
Yes! That did the trick, thank you so much!
