HOW TO MAINTAIN SERVICE BOOK LEAVE ACCOUNT, DOWNLOAD LINK IN DESCRIPTION & EXCEL WILL DO THE REST

Описание: LEAVE ACCOUNT OF THE SERVICE BOOK IS VERY LENGTHY PROCESS AND DIFFICULT TO MAINTAIN. Now maintain your own leave account on Excel, you can check your leave balance and have a track record of your leaves.
Here is the link of this video, you can download it and even edit it.
https://drive.google.com/file/d/0B8lb...

THE PROBLEM IS SOLVED HERE, JUST ENTER THE DATES AND THE REST OF THE CALCULATIONS WILL BE DONE AUTOMATICALLY. I HAVE SHARED THE GOGGLE DRIVE LINK OF THE WHOLE FILE, FROM WHERE YOU CAN DOWNLOAD THE FILE.
SHEET 1
HERE I HAVE JUST SHOWN YOU THE COLUMN AND ROWS, TO MAKE THE BASIC LEAVE ACCOUNT ON EXCEL. THE COLUMNS IN WHITE COLOUR ARE THOSE WHICH YOU HAVE TO HIDE AFTER PUTTING THE FORMULAE.
SHEET 2
HERE I HAVE GIVEN ALL THE FORMULAE SO THAT YOU CAN UNDERSTAND FULLY HOW THIS EXCEL SHEET WOULD WORK FOR YOU. ONE THING TO KEEP IN MIND HERE IS THAT THE FORMULAS IN ROW 1 ARE SLIGHTLY DIFFERENT FROM ROW 2. BUT FROM ROW 2 ONWARD THESE ARE THE SAME.
SHEET 3
THE DATES WHICH ARE SHOWN IN RED COLOUR ARE THOSE WHICH YOU HAVE TO ENTER IN THIS SHEET.
SHEET 4
HERE IS THE FINAL LOOK OF YOUR LEAVE ACCOUNT.