How To Use Excel Date Function

Use the day function to find the day of a date.

How to use excel date function. For example there is data like the image below. In another cell use the datedif formula with the ym parameter. Converts a date in the form of text to a serial number. Date function 1 date a2 b2 c2 the result is january 31 2018. For example you can use the date function to create the dates january 1 1999 and june 1 2010 like this.

Add 10 years to date in another cell. Day serial number you probably know by now that serial number is the date. Press the shortcut ctrl semi colon ctrl. The value of the year argument can include one to four digits. Year this is a required argument.

In this example we re wanting to see the date that s 10 years past an existing date. Date year a2 10 month a2 day a2 the excel date function can also be used with other dates like to add time to an existing date. Date function in excel. Date function in excel is a date and time function which represents the number provided to it as arguments in a date and time code the arguments it takes are integers for day month and year separately and gives us result in a simple date the result displayed is in date format but the arguments are provided as integers method to use this formula is as follows day year month day in a sequential based. In this example the start date is in cell d17 and the end date is in e17.

Returns the serial number of a particular date. Let s perform a small experiment. Like most of excel date functions eomonth can operate on dates input as cell references entered by using the date function or results of other formulas. If you know how it is stored and read by excel it will help you write complex logical excel date functions. This argument can be the actual serial number form of the date or the literal date in double quotes.

A data in excel is not stored in excel the way we see it. The results correspond to the numbers entered in the year month and day arguments. Date 1999 1 1 jan 1 1999 date 2010 6 1 jun 1 2010. The date function is also useful when providing dates as inputs for other functions such as sumifs or countifs since you can easily assemble a date using year month and day values that come from a cell reference or formula result. The date function creates a valid excel date using individual year month and day components.