Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Count rows that contain specific values in Excel
  • Two-column Lookup in Excel
  • Extract all partial matches in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Multi-criteria lookup and transpose in Excel

Data Analysis Examples

  • Subtotal function in Excel
  • Use Data Form to input, edit and delete records in Excel
  • Excel Bar Chart
  • Reverse List in Excel
  • Randomize/ Shuffle List in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Data validation must not exist in list
  • Excel Data validation date in specific year
  • Excel Data validation require unique number
  • Excel Data validation exists in list

Get day from date in Excel

by

This tutorial show how to Get day from date in Excel using the example below.

If you need to extract the day from a date, you can use the DAY function.

Formula

=DAY(date)

Explanation of how this formula works

In the generic form of the formula above, the date must be in a form that Excel recognizes as a valid date.

Worked Example:   How to generate series of dates increment by 1 year from a single start date in Excel

Here’s how the formula works:

The DAY function takes just one argument, the date from which you want to extract the day. In the example, the formula is:

=DAY(B4)

B4 contains a date value for January 5, 2016. The DAY function returns the number 5 representing the day component of the date.

Worked Example:   DAY function: Description, Usage, Syntax, Examples and Explanation

Note that you can use DAY to extract the day from a day entered as text:

=DAY("1/5/2016")

But this can produce unpredictable results on computers using different regional date settings. In general it’s better (and more flexible) to supply an address to a cell that already contains a valid date value as the argument for DAY.

Worked Example:   Add years to date in Excel

Post navigation

Previous Post:

Get date from day number in Excel

Next Post:

Display Date is same month in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • UPPER function: Description, Usage, Syntax, Examples and Explanation
  • How to remove trailing slash from url in Excel
  • How to count specific words in a range in Excel
  • How to get first word in Excel
  • How to count total characters in a range in Excel
  • Add workdays to date custom weekends in Excel
  • Extract time from a date and time in Excel
  • Add workdays no weekends in Excel
  • Convert time to time zone in Excel
  • Calculate years between dates in Excel
  • How to calculate simple interest in Excel
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles