Help

Re: WORKDAY_DIFF returning Error

Solved
Jump to Solution
504 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MegFox
4 - Data Explorer
4 - Data Explorer

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! 

1 Solution

Accepted Solutions
Brian_Swanson
6 - Interface Innovator
6 - Interface Innovator

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.  

See Solution in Thread

2 Replies 2
Brian_Swanson
6 - Interface Innovator
6 - Interface Innovator

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.  

Yes! That did the trick, thank you so much!