Question about Microsoft Office Standard for PC
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
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.
Posted on Sep 06, 2007
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 25, 2013 | New Bright 384 Holiday Express Animated...
Dec 12, 2010 | New Bright 384 Holiday Express Animated...
Sep 26, 2010 | Microsoft Excel for PC
Dec 15, 2009 | New Bright 384 Holiday Express Animated...
Dec 04, 2009 | Lionel 11000 Holiday Tradition Express...
Nov 28, 2009 | New Bright 384 Holiday Express Animated...
Nov 27, 2009 | New Bright 384 Holiday Express Animated...
Mar 31, 2009 | New Bright 181 Toy Christmas Train
Dec 27, 2008 | Microsoft Office Standard for PC
614 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: