Syntax Day ( date ) The required date argument is any Variant, numeric expression, string expression, or any combination of these that can represent a date. If date contains Null, Null is returned. Note: If the Calendar property setting is Gregorian, the returned integer represents the Gregorian day of the month for the date argument.
Day Required. A positive or negative integer representing the day of the month from 1 to 31. If day is greater than the number of days in the month specified, day adds that number of days to the first day in the month. For example, DATE (2008,1,35) returns the serial number representing .
The DAY function takes as an argument the date of the day you are trying to find. Dates can be provided to the function by using another date function, by using an expression that returns a date, or by typing a date in a datetime format. You can also type a date in one of the accepted string formats for dates. Values returned by the YEAR, MONTH and DAY functions will be Gregorian values ...
For information about the DAY function, see DAY function. Description Returns the number of days between two dates. Syntax DAYS (end_date, start_date) The DAYS function syntax has the following arguments. End_date Required. Start_date and End_date are the two dates between which you want to know the number of days. Start_date Required.
Then the 1 represents the first day of that month. The result for the DATE function is 5/1/2016. Then, we subtract that from the original end date in cell E17, which is 5/6/2016. 5/6/2016 minus 5/1/2016 is 5 days. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.