Date Functions: Month

Businesses are "date driven." Bills need to be paid on time. The DATE functions can be used to format as well as calculate.


Before You Begin: Make a Copy

Select the Original Data sheet.

Right click and make a Copy.

Name the new sheet: Date Functions.


1. Try This: Add a Label

Go to the Date Functions sheet.

Select Cell F1.

Type the following label: Date: Month


2. Try This, Too: Use a Date Function

Select Cell F2.

Go to Formulas->Function Library-> Date&Time.

Click on: MONTH.

Keep going...

Formulas->Function Library-> Date&Time->MONTH

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: DATE Functions MONTH