Examples of Date Formula in Excelįollowing are the different examples: Example #1Ī simple date format can be used as below. The same logic will apply to the day also. In the below example, we took the year as 2019, but we gave -3 in the month argument hence it reduced 3 months from 2019 return results as the 9 th month of 2018 with the same date. If we give a negative value for the month argument, the function will reduce that number of months from that year and will return results. Using a negative value in the year will return results as #NUM! as below. We can use negative values also in these arguments except for the year. So, if I give 30 in the date argument, it should result in 2 because 28+2 will result in 30. Consider an example of February, which has 28 days. If we give a number more than 12, it will repeat to give from January again, which means the second month will be February if we give 14, 12+2.ĭate – Similarly, there are also 31 days for a few months and 30 days for a few months depending on the month it will calculate the number given in the date argument and return the results. Month – We already know that there are 12 months. Observe the below screenshot for reference. Year – If we give the year argument as 300 using the Date formula, it will add 300 to 1900 and give results as the 2200 years. Hence, we will see how excel will interpret if we give year, month and date out of its range. As mentioned earlier, the date range starts from to.
0 Comments
Leave a Reply. |