SOLVED
Home

Employee attendance tracker using excel

Highlighted
ALINA STANGU
New Contributor

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

 

2 Replies

Re: Employee attendance tracker using excel

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

Solution

Re: Employee attendance tracker using excel

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!