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

Lookup and Reference Examples

  • How to get last column number in range in Excel
  • How to get relative column numbers in a range in Excel
  • Count rows that contain specific values in Excel
  • How to use Excel COLUMN Function
  • How to get first row number in range in Excel

Data Analysis Examples

  • Understanding Pivot Tables in Excel
  • Excel Line Chart
  • How to count table rows in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How To Remove Duplicates In Excel Column Or Row?

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation
  • Excel Data validation only dates between
  • Excel Data validation number multiple 100
  • Excel Data validation with conditional 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:   Display Days in month in Excel

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:   Get week number from 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
  • How to Separate Text Strings in Excel
  • Join cells with comma in Excel
  • DOLLAR function: Description, Usage, Syntax, Examples and Explanation
  • Split numbers from units of measure in Excel
  • FIND, FINDB functions: Description, Usage, Syntax, Examples and Explanation
  • How to show last updated date stamp in Excel
  • Convert text timestamp into time in Excel
  • Get days between dates in Excel
  • Get work hours between dates and times in Excel
  • Get fiscal quarter from date in Excel
  • ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles