Page 311 - JoFA_2022

Extract month information the month, define Value as the cell that contains
About the You also have various options to extract and the date. Define Format_text as “mmm.” See the
author present information about the month. We will screenshot below that shows the abbreviated month
start with the MONTH function. The syntax in cell E3.
Kelly L. Williams, for MONTH is MONTH(serial_number), where In order to extract the month and present it as
CPA, Ph.D., MBA, serial_number is the cell that contains the the full name of the month, define Value as the
is an associate date. You can see the formula in cell C3 of the cell that contains the date and Format_text as
professor of screenshot below. “mmmm.” See the screenshot below that shows the
accounting at the You can also use the TEXT function to extract full name of the month in cell G3.
Jones College of month information from a date. For example, to See the screenshot at the bottom of the page for
Business at Middle extract and present the three-letter abbreviation for the results of these formulas.
Tennessee State
University.

journalofaccountancy.com July 2022 | 43