Hello! So I’m using a formula to track how many days someone has been in training. It’s a pretty simple IF statement that uses a few date columns: Training Start and Training End. What I want to see are, IF training is complete (Training End has a date), the number of workdays it took and if it’s not complete (Training End is empty), how many workdays it’s been so far. Here’s what I have:
IF({Training End}<>“”,WORKDAYS({Training End},{Training Start}),WORKDAYS(TODAY(),{Training Start}))
What I’m finding is the formula works fine if the Training End has a date in it, but if training is still ongoing and there’s no date, it just returns zero. Which is weird b/c the start date is clearly before today. I should mention that both of these date columns are actually Mirror columns pulled in from different boards, don’t know if that makes a difference.
Also tried troubleshooting this a bit and just wrote
WORKDAYS(TODAY(),{Training Start})
and it worked perfectly. Only when paired with the other part of the formula does it return zero.
Help?