End_date required argument The end date. In this example you are adding 30 days to the date in cell A2 Excel displays 712011 as the due date. Enter the following formula into a blank cell to locate the result and then drag the fill handle down to the cells for getting the future date as following screenshot shown.
In this example you are adding 30 days to the date in cell A2.
In this example you are adding 30 days to the date in cell A2. The result for the DATE function is 512016. For example to find the serial number for the date taking the values in cells A2 A3 and A4 as the year month and day arguments respectively the formula is. And this gives us December 23 as expected.