Leave Tracker

**markusvirus** · 04-19-2017, 12:28 AM

Hi Experts,

Can someone help me with the file I'm working on. I am trying to make a leave tracker to track down the leave balance and used leaves by employees. What I want to achieve is to automatically add hours depending on the employee's regularization date, and the date today since they will earn 60 hours upon regularization date, and 10 hours every month after that. I attached my example file where I manually inputted the data. And if it's not too much to ask, I have a sheet named as "Request", is there anyway that I can link it to the "Records" sheet? Thanks!

**ImranBhatti** · 04-19-2017, 01:35 AM

Is the Request sheet showing the result that is manually entered. If yes,you need to further explain it coz we see that the 16 hours are also in the Records sheet which you put there.

I always try to endorse such posts where the OP is unable to explain what he wants to get help for.But I think he really needs the help.