Microsoft Office Tutorials and References
In Depth Information
showed you speciﬁ c, handy examples of formulas you can build to tackle certain date and
time calculation tasks. At this point, you should know how to:
Type dates and times so that Excel recognizes them correctly.
Use date functions to perform calculations such as determining a person’s age,
determining the day of the year, determining the day of the week, or calculating
Use time functions to perform calculations such as determining the difference
between two times or converting from military time.