DAY function - The function returns the date value of a specific date in Excel

The following article introduces you to the DAY function - 1 of the functions in the date and time group function is very popular in Excel.

DAY function - The function returns the date value of a specific date in Excel Picture 1

Description: The function returns date values in specific date, month and year format in Excel.

Syntax: DAY (serial_number)

Where: serial_number is the date value of the date you are looking for.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

For example:

Calculate date values in the following date formats:

DAY function - The function returns the date value of a specific date in Excel Picture 2

- In the cell to calculate enter the formula: = DAY (F7).

DAY function - The function returns the date value of a specific date in Excel Picture 3

- Press Enter -> return value is:

DAY function - The function returns the date value of a specific date in Excel Picture 4

- Similarly copying the formula for the remaining values results:

DAY function - The function returns the date value of a specific date in Excel Picture 5

- Where the day, month, and year values are individual values -> enter the following formula: = DAY (F12 & "/" & G12 & "/" & H12) -> press Enter -> return value is:

DAY function - The function returns the date value of a specific date in Excel Picture 6

Above are instructions and some specific examples when using the DAY function in Excel.

Good luck!

Micah Soto

Update 19 May 2020

You should read it

May be interested

TIME function - Function returns decimal numbers for a specific time value in Excel
time function: the function returns the decimal number for a time value. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: time (hour, minute, second)
POISSON function - The function returns the Poisson distribution in Excel
in predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.
COUPPCD - The function returns the previous coupon date before the settlement date in Excel
in the previous article introduced to you the function returns the next coupon date after the settlement date. the following article introduces you to the couppcd function - the function returns the previous coupon date before the settlement date.
YEARFRAC function - The function returns the fifth calculated by the number of whole days between two specific dates in Excel
yearfrac function: the function returns the fifth calculated by the number of whole days between two specific dates in excel. syntax: yearfrac (start_date, end_date, [basis])
Excel date function - Usage and examples
the date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake.
STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel
standardize function: the function returns the normalized value from a distribution characterized by mean and standard_dev arguments. syntax: standardize (x, mean, standard_dev)
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel
isoweeknum function: the function returns the ordinal number of the year of the week that contains the given date. syntax: isoweeknum (date)

DAY function - The function returns the date value of a specific date in Excel

You should read it

May be interested

Office information