Hi I need some help with setting up an accrual spreasheet to keep track of staff holidays, can someone help me with the formula? i need the formula to calculate the holiday from the start date of the employee to the current date. Any Ideas? Many Thanks
Hi,
I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula.
However here are some tips:
Set up a column with the start date for each employee and use the today() function to get today's date.
You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month.
For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together.
Good luck
K
656 views
Usually answered in minutes!
×