98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Setting up an annual leave spread sheet
Setting up an annual leave spread sheet
· Urgent Priority · Version 365
Thu 23 May 2024, 16:11Delegate Jacqui said...
Jacqui has attended:
Excel Introduction course
Setting up an annual leave spread sheet
I would like info on this, as I need to create a new spread sheet for the new financial year for 8 colleagues. I have one which was set up previously for last year, but I believe I need to start the new one from scratch
Tue 28 May 2024, 10:39Trainer Martin said...
RE: setting up an annual leave spread sheet
Hi Jacqui,
Thankyou for your question to the forum.
To make a start with doing annual leave deductions, here is a link on how to do these calculations based on deducting annual leave on an hourly or daily basis:
https://buddypunch.com/blog/calculate-vacation-hourly-employees/
Hope this helps. Please let me know if you need any more support giving more details around what exactly you need to calculate as regards annual leave entitlement
Kind regards
Martin Sutherland
(IT Trainer)
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding Formulae in the Formula BarIt is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar. |
