The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods.

Supported versions

  • All Excel versions

DAY Function in Excel Syntax




The actual date that you want to find the day from.


formula returns 30 as day number for the date 7/30/2015.

DAY Example 1

Download Workbook


  • Excel stores dates as numbers. Excel assumes that the date 1/1/1900 is 1 and increases this number by 1 for each day. For example; 12/31/2018 is equal to 43465. Because of this, you should avoid using dates as text although the DAY function in Excel can operate with dates that match your local format. Use the DATE function to generate a Date value.
  • Day number of a date can be retrieved via number formatting as well. Use d as Custom Format on the date cell to see the day only. However, this will not change the actual value and only show the formatted value. For more information see Number Formatting in Excel - All You Need to Know