Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

vacation day formula - help

Topic Labels: Formulas
1109 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Aly_Fossett
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.