Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11The DAY function - The function returns the day of the day, month and year in Excel
The following article details how to use the DAY function, the function returns the day of the day, month and year in Excel.
Description: The function takes a date value from a date value. The return value is an integer between 1 and 31.
Syntax: DAY (serial_number) .
Inside:
serial_number is the date value that you want to extract the date value.
For example:
Separate date values from the following dates:
In the cell to calculate enter the formula: DAY (C7) .
Press Enter -> separated date value results:
Copying the formula for the remaining values results in:
If, if the month does not have 31 days, you still enter a date containing 31 days -> the function returns the # VALUE error value ! .
Above is the usage and some notes when using the DAY function in Excel.
Good luck!
4.5 ★ | 2 Vote
Lesley MontoyaYou should read it
- How to separate the date, month, and year columns into 3 different columns in Excel
- YEAR - The function returns the year corresponding to a date in Excel
- MONTH function in SQL Server
- SQL Server YEAR function
- MONTH function - The function converts a serial number into a month in Excel
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel
- DATEPART function in SQL Server
May be interested
- SQL Server YEAR function
sql server's year function returns a 4-digit integer that is the year value in the timestamp passed. - WEEKNUM function - The function returns the week number of the year in Excelweeknum function - the function returns the ordinal number of the week of the year of the specified day in that week. there are 2 systems used in the function to determine the ordinal number of the week: - system 1: week with january 1 is the first week of the year and numbered as 1. - system 2:
- MONTH function in SQL Serverthis article will show you in detail how to use the datetime month () processing function in sql server with specific syntax and examples to better visualize and capture functions.
- CHISQ.TEST function - The function returns the independence test in Excelchisq.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 Excelthe 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
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- DATEPART function in SQL Serverthe datepart function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is an integer type (int)
Office information
- MINUTE function - The function converts a serial number into a minute in Excel
- MONTH function - The function converts a serial number into a month in Excel
- NOW function - The function returns the current date and time in Excel
- Instructions on how to enter chemical formulas in Excel
- How to reduce the size and size of Word document files containing images
- How to insert images into Excel spreadsheets
MINUTE function - The function converts a serial number into a minute in Excel
MONTH function - The function converts a serial number into a month in Excel
NOW function - The function returns the current date and time in Excel
Instructions on how to enter chemical formulas in Excel
How to reduce the size and size of Word document files containing images
How to insert images into Excel spreadsheets