SOLVED

Employee attendance tracker using excel

Copper Contributor

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).

 

2 Replies

Update, it seems that it's only doing this on the 30th of certain months. Below is a snap shot of it.

best response confirmed by ALINA STANGU (Copper Contributor)
Solution

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!

1 best response

Accepted Solutions
best response confirmed by ALINA STANGU (Copper Contributor)
Solution

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!

View solution in original post