Manual file processing can be a cause of your company losing money and your staff losing interest in their responsibilities. The simplest way to increase all business procedures and enhance your statistics would be to manage everything with cutting-edge software like DocHub. Deal with all your files and Save Vacation Policy in Excel in just few mere seconds and save more time for relevant tasks.
With DocHub, you possess limitless use of your files and Templates available for you at any time. Check out all features today with the free DocHub account.
welcome to Excel magic trick number 202 hey if you want to download this workbook and follow along click on my youtube channel then click on my college website link and you can download the workbook excel magic trick 185 to 202 and this trick here - OH - were going to see how to calculate vacation days heres the setup when you start working you automatically get 20 days years until you get more days or five so you have to work five years but then you get one extra day for when you get to your fifth year and one extra day for every additional year worked so heres some names heres the higher date lets go ahead and do the today formula because we want to have this spreadsheet update no matter when we open it and tell us how many vacation days so well go equal today and the today function is an argument list function that calculates just todays date ctrl enter and then double click and send it down pay today is the 9th of January 2009 now years worked we have a higher date and toda