Forum Discussion
Solved
Employee attendance tracker using excel
I'm having an issue getting the employee leave tracker to recognize days left when it comes to any month on the 30th day. I'll place in sick leave from 1/30/18 to 1/30/18 and it will come up as '0' in the days field instead of '1'. It only does this for the 30th of every month. In addition it effects the calendar view as well since it doesn't count the day (but it does color it).
Figured it out! This is the formula to use
=DATEDIF([@[Start Date]], [@[End Date]],"d")+1
Not the =date360 or whatever the template came with :) Yayyy!
2 Replies
Figured it out! This is the formula to use
=DATEDIF([@[Start Date]], [@[End Date]],"d")+1
Not the =date360 or whatever the template came with :) Yayyy!
Update, it seems that it's only doing this on the 30th of certain months. Below is a snap shot of it.
