How to Calculate a Birthday in Excel

If you are looking for an engaging, educational math activity to capture the minds of your children during a home schooling session -- or on a weekend afternoon -- then consider teaching them how to format a Microsoft Excel worksheet to determine a person's age. Your children can practice this "math project" using your family members as the subjects. They will learn both math and computer skills through this project.

Instructions

    • 1

      Open a blank Microsoft Excel spreadsheet. Often you can access Excel as an icon on your Start menu. If you do not see it listed there, then from the Start menu click "All Programs," "Microsoft Office" and "Microsoft Office Excel." You will see a blank spreadsheet open.

    • 2

      Click on cell "A1." You will be typing text in this cell. If the cell is too small for text, then grab the vertical bar on the "A" column header, and drag it to the right. You want enough space in your cell to write a sentence.

    • 3

      Write your "clues" to help your children figure out the birthday of the person in question. For example, you might write the following: "Sarah is 10 years old and was born in the month of March on the 11th day. Today's date is March 11, 2011. What is Sarah's birthday?"

    • 4

      Allow your children to practice typing their equation to answer your question in B1. In this case, your child will write "2011" in "B1" and "10" in "B2." In "B3," your child will type the following Excel formula: "=INT(A1-A2)" without the quotes. The answer that will appear is 2001. Therefore, Sarah was born in 2001.

    • 5

      Repeat hypothetical problems as in steps 3 and 4 for practice.

Learnify Hub © www.0685.com All Rights Reserved