Step-by-Step Directions For Tracking FMLA in Microsoft Excel
- 1). Click on cell "F2" and type "Accumulated Days."
- 2). Click on cell "I2" and type the amount of family leave that you have accumulated, in days. You should be able to get this information from your company's human resources department.
- 3). Click on cell "A1" and type "Date."
- 4). Click on cell "B1" and type "Used."
- 5). Click on cell "C1" and type "Remaining."
- 6). Click on cell "C4" and type the formula "=I2-B2."
- 7). Click on cell "B3" and type the formula "=C2-B3." Press the "Enter" key, then click on cell "B3" again. Click on the fill handle (the little black square in the bottom right of the cell) and then drag it down to cell C100. This copies the formula all the way down the column to C100.
Source...