Set Up the Worksheet

• 1). Start a new Microsoft Excel workbook.
  
  
• 2). Set your page orientation to "Portrait." In Excel 2007, click on the "Page Layout" tab in the ribbon at the top of the screen. Click on "Orientation," then "Portrait" under the "Page Setup" section.
  
  
• 3). Add your page header. This is just a way to know what you are looking at in the event that you need to print the worksheet. Select cells A1 to I1. Click on the "Merge and Center" button; this button is under the "Alignment" section on the "Home" tab. Type in whatever you want in the newly merged cells. For example, you can use "Family Medical Leave Tracker" or "FMLA Worksheet."
  
  
• 4). Select cell G2 and type "Starting Amount." Select cell "I2" and type in the amount of family leave that you have accumulated so far. You can get this amount from your company's Human Resources department or by checking the FMLA guideline.
  
  
• 5). Select cell A3 and type "Date" for the column header. This tells you the type of data that is tracked in the columns.
  
  
• 6). Select cell B3 and type "Amount Used." This column shows how much time you have used for a certain date.
  
  
• 7). Select cell C3 and type "Amount Left." This column shows how much family leave time you have remaining. Resize all of the columns so the column heading can be easily read.
  
  

Adding the Formulas

• 1). Select cell C4 and type in the formula, "=I2-B4" before pressing the "Enter" key. This will subtract the amount used from the starting amount.
  
  
• 2). Select cell C5 and type in the formula, "=C4-B5" then hit the "Enter" key. This will keep track of how much time you have left after entering different amounts as the days go by.
  
  
• 3). Copy the formula from cell C5 to the other cells in the column to the end of the page. To do this, select cell C5. Place the mouse cursor at the bottom, right corner of the cell. The cursor will turn into a thin, black cross. Click the edge and drag it down to the bottom of the page.
  
  
• 4). Enter the dates and the amount of time used each time you use FMLA time. As you continue to document the dates and amount of family leave time used, the sheet will calculate how much you have left.