• ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips

No products in the cart.

  • ChatGPT Business
  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
    • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
Excel

Using DAY, MONTH, YEAR functions to extract date in Excel

0 Comments

Using DAY, MONTH, YEAR functions to extract date in Excel: To extract the Day, Month, and Year values from a specific date in Excel, you can use three processing functions: DAY, MONTH, and YEAR. These functions are simple, easy to use, and are often used in combination with other functions such as SUMIFS to calculate sales, debts under multiple conditions (including time conditions), used with IF function, VLOOKUP function, combined with a string, used in administration to determine the end date of the month for timekeeping, building attendance sheets, payroll sheets, applications in finding birth years when creating a student list … This article will guide you on how to use DAY, MONTH, YEAR functions.

1. DAY function

The DAY function is used in Excel to return the value as a day in an Excel cell. The day value is returned as an integer from 1 to 31.
Function syntax: =DAY(serial_number)

Where: serial_number: required argument, is the date, month, year value you want to extract the day

For example, we have a time table as shown below.

Using DAY, MONTH, YEAR functions to extract date in Excel

Using DAY, MONTH, YEAR functions to extract date in Excel

Note: Excel stores dates as a continuous serial number. By default, January 1, 1900, is 1 and September 17, 2012, is 41,169 because it is 41,169 days after January 1, 1900.

Thus:

  • In cell A4, 41,169 corresponds to September 17, 2012
  • In cell A7, 42,857 corresponds to May 2, 2017
  • In cell A9, 43,274 corresponds to June 23, 2018
  • In cell A10, 43,800 corresponds to December 1, 2019

To extract the day of the time column, apply the above function structure, we have the formula for cell B2 as follows:

=DAY(A2)

Copy the formula for the remaining cells in the Day column to get the result:

Using DAY MONTH YEAR functions to extract date in2. MONTH function

The MONTH function is used in Excel to return the value as a month in an Excel cell. The month value is returned as an integer from 1 to 12.
Function syntax: =MONTH(serial_number)

Where: serial_number: required argument, is the date, month, year value you want to extract the month

Still with the above example, to extract the month of the time column, we have the formula for cell C2 as follows:

=MONTH(A2)

Copy the formula for the remaining cells in the Month column to get the result:

Using DAY, MONTH, YEAR functions to extract date in Excel

Using DAY, MONTH, YEAR functions to extract date in Excel

2. YEAR function

The YEAR function is used in Excel to return the value as a year in an Excel cell. The year value is returned as an integer from 1900 to 9999.
Function syntax: =YEAR(serial_number)

Where: serial_number: required argument, is the date, month, year value you want to extract the year

Still with the above example, to extract the year of the time column, we have the formula for cell D2 as follows:

=YEAR(A2)

Copy the formula for the remaining cells in the Year column to get the result:

Using DAY, MONTH, YEAR functions to extract date in Excel

Using DAY, MONTH, YEAR functions to extract date in Excel

In conclusion, language learning is a valuable and rewarding endeavor that can bring numerous benefits, from enhancing communication skills to fostering cultural understanding and opening up new opportunities. While it may require effort and persistence, the benefits of language learning can last a lifetime and enrich both personal and professional experiences. Whether you are learning a new language for practical or personal reasons, it is important to approach it with an open mind, a positive attitude, and a willingness to engage with the language and its culture. With these qualities, anyone can become a successful language learner and enjoy the many benefits that come with it.

 

Rate this post
50
296 Views
Tips for aligning print margins quickly in ExcelPrevTips for aligning print margins quickly in ExcelMay 9, 2023
How To Blur Images In PowerPoint Quickly And EffectivelyMay 16, 2023How To Blur Images In PowerPoint Quickly And EffectivelyNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $6.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
Products
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Project Professional 2024 Project Professional 2024 $33.00
  • Windows Server2008 R2 Remote Desktop Services device connections (20)cal Windows Server2008 R2 Remote Desktop Services device connections (20)cal $29.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Windows Server 2016 Standard Key Global Windows Server 2016 Standard Key Global
    Rated 4.80 out of 5
    $10.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Microsoft SQL Server 2019 Enterprise Microsoft SQL Server 2019 Enterprise $39.00
  • Windows 10 Pro Key Global Genuine Key Windows 10 Pro Key Global Genuine Key
    Rated 4.78 out of 5
    $6.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.