Looking for an Excel formula that will add 1.25 days at the end of every month
Posted on 2012-09-17
I am working on a spreadsheet that calculates employees' accrued leave.
At the end of every month, an employee earns 1.25 days of annual leave. How would I write a formula that does this?
I tried 15/365. 15 is the number of days earned in a year (1.25 x 12months), then dividing by 365 would give me the leave the employee earned to that date. Human Resources says this is incorrect, they don't want the 1.25 days added to the earned leave until the employee has finished the month.
Some staff have been here for several years. I need something that says "for every end of the month a staff member has earned since they began working, add 1.5 days.
I haven't a clue what such a formula would look like. Any ideas?
I am using Excel 2010, Windows version