Microsoft Office Tutorials and References

In Depth Information

**Summary**

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.

■

16

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

holiday dates.

■

Use time functions to perform calculations such as determining the difference

between two times or converting from military time.

■