Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Get day from date

Most of the times there is a need to get the day from a given date and there are several options of doing this based on your requirements. There is a built-in function in Excel called the DAY function which is used to get a day from the date. This function returns the numbers 1-31 (date) when supplied with a date.

Syntax

=DAY(date)

Parameter

date–  Includes numbers from 1 to 31 (valid date) in a serial number format.

How does the formula work?

  1. The DAY function has the date parameter which should be a valid date between 1 to 31 and these values are returned as the function of the date.
  2. For example, if the date says 2/12/2006 (Note that the date must be in a format that the Excel spreadsheet recognizes). Here in the example, the day is ‘12’. The DAY function takes just one parameter which is the date for which the day value needs to be extracted. Therefore, this function returns number 12 which is the day component of the date specified.

Note on usage

  1. You can also enter the date as a text using doubles quotes, for example, =DAY(“2/12/2017”). But this can sometimes produce unpredictable results because different computers use different regional date settings. So, it is always better to supply the (cell number) address of the cell containing the date (valid).
  2. One can use the DAY function into other functions such as the DATE function to input a day value.

Example

Let us see different examples to get a day from the date as shown in the results given below.

Figure 1. Using the DAY function to get the day from the date.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
I have multiple columns on my spread sheet and want to switch from A-Z to Z-A based on values in column A
Solved by V. H. in 38 mins
Concat formula is incorrectly formatting the date in column C. Currently column B has dd/mm/yyyy and I require mm/dd/yyyy
Solved by Z. Y. in 31 mins
I need a formula that will allow me to calc before a certain date and after a certain date. =if(A2<=DATE(2015,8,27),(F2*1.14),(F2*1.15)) It just multiplies column F with 1.15. I'm assuming I need to bring in the date column into the equation?
Solved by M. Q. in 20 mins
I need assistance setting up a time sheet formula where I can create a column of contiguous dates down the left hand side of the spread sheet. So I can copy a contiguous column of dates, rather than entering each date manually. I would only need to have work days in the list, ie Monday to Friday inc. with a couple of spare lines between each week.
Solved by Z. Y. in 40 mins
Example: If a loan closes between October 1st & 15th, the first mortgage payment is due November 1st. If it closes between October 16th & 31st, the first payment is due December 1st.
Solved by S. S. in 15 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc