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...