![]() The reason is that the DATE functions format requires all three parameters to perform the calculation. So, it returns the date ! You might ask why we need the Month and year functions when we just want to add 15 days to the original date. Finally, the DATE() function combines the three values returned (2019, 6, and 16) into a Date.When you add 15 to this result, you get 1 + 15 = 16. The DAY function extracts just the day part of the date in cell A2.The MONTH function extracts just the month of the date in cell A2. ![]() So YEAR(A2) in our case, will return 2019.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |