vacation day formula - help

Topic Labels: Formulas
582 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I am having trouble with my vacation day calculation when an employee is only taking one day off. I have a formula to count the days requested and they always show up as negative which is what I want to subtract from their approved days, but when they request 1 day is comes up as a +1 and throws the calculation off. Could someone help me with this? I know it has to be a simple fix. Thanks! 


This is the formula I am using: 

WORKDAY_DIFF({End date (vacation)}, {Start date (vacation)})
1 Reply 1

Try DATETIME_DIFF() instead. It will give 0.