• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
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
41
270 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 Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.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
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows 10 Pro Key Global Genuine Key Windows 10 Pro Key Global Genuine Key
    Rated 4.78 out of 5
    $6.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Windows 10 Pro N Key Global Windows 10 Pro N Key Global
    Rated 4.83 out of 5
    $10.00
  • Windows Server 2025 Remote Desktop Services 50 User Connections Windows Server 2025 Remote Desktop Services 50 User Connections $25.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Microsoft Visio Professional 2013 Key 1PC Microsoft Visio Professional 2013 Key 1PC $9.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.