![]() The above number represents the number of days from to the given date. If we want the serial number for that date to convert the cell to a General format. 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.
0 Comments
Leave a Reply. |