The attached file will help to track leaves year wise.
To help yourself you can copy this excel sheet and rename it year wise to maintain the leave record for the whole period of articleship.
Start with that month sheet when you have joined articleship.
Enter the year i.e 2013, 2014 etc in the January sheet as it will update the same in all the sheets.

As an when you take the leave Put the custom key label such as V, S or any other of your own and note the total Leave  for that month
After the completion of the year total the leaves of all the months and enter it into the Leave Calc sheet in the respective year
It will automatically compute the eligible leaves and give you the excess/(shortfall).
(Submitted by -Anish Gandhi-A CA Student from Mumbai)
Tags:

More Under CA, CS, CMA

0 Comments

  1. CA Sandeep Kanoi says:

    The eligible leave is 156 only in the excel sheet as if you put 156 in the leaves taken it will show you 1 in excess/short cell.
    The formula is created in such a way that when nothing is put it shows 183 but when number are inputed it shows the correct eligible leaves.

  2. Chandravijay Shah says:

    Mr Moderator

    Pl always moderate / scan the Articles / Material before putting the same on the Site, especially the ones which are sensitive like the one under reference.

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Posts by Date

October 2020
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031