How To Use Excel Date Function

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

How to use excel date function. Date function in excel. Converts a date in the form of text to a serial number. This function is useful in formulas where you need to calculate an age. 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 the formula the y returns the number of full years between the two days.

How do the date function results in column d. For example there is data like the image below. How to use date function in excel. For example you can use the date function to create the dates january 1 1999 and june 1 2010 like this. The value of the year argument can include one to four digits.

Let s perform a small experiment. In this example the start date is in cell d17 and the end date is in e17. Year this is a required argument. Use datedif again with ym to find months. A data in excel is not stored in excel the way we see it.

In this example we re wanting to see the date that s 10 years past an existing date. The date function creates a valid excel date using individual year month and day components. To isolate only the day of the full date we use the day function. This argument can be the actual serial number form of the date or the literal date in double quotes. 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.

Press the shortcut ctrl semi colon ctrl. Use datedif to find the total years. The results correspond to the numbers entered in the year month and day arguments. There is a single argument for the day function. Add 10 years to date in another cell.