Section outline

  • Dates and time
    • Excel employs serial numbers to represent dates and time. You find a brief description of this representation and some examples in the following documents.
    • Dates and time in Excel File
    • Some examples on using dates and times in Excel File

    • For a complete list of date and time functions in Excel, see the Excel help or the following link:

    • Tutorial on Microsoft Excel on www.bettersolutions.com URL

    • Now try to create a worksheet as suggested by the following pdf file, by using convenient Excel functions. Try to discover them! (Some hints are given.)

      Notice that data contained in orange cells are typed by the user, whilst those in yellow cells are calculated by means of formulas.

    • An exercise on date formulas in Excel File

    • You will probably find the following resource useful:

    • Calculating an age between two dates using the DATEDIF function URL

    • Notice also what happens in case of user's birthday. (Hint: explore the use of logical functions (for instance IF and AND) in Excel.)

    • It's your birthday today! File