It also maintains the last day of February in leap years. The EDATE function correctly returns the last day of month if the start day is 31.įor example, the formula below returns 3, which is a date 3 months after 3: =EDATE(A3, B3*12) EDATE formula to get last day of month The first form is more contact while the second variation is more convenient to use when you have a number of years in another cell. To move a date 10 years backward, the formulas are: The result is a date on the same day of the month, a specified number of months before or after the initial date.įor instance, to move a date 10 years forward from the date in A3, you can use one of these formulas: With the start date in a predefined cell, say C4, the formulas are: To get a date 5 months before 30 January 2025, the formulas go as follows: Apply the desired DATE format to the formula cell.įor example, to return a date 5 months after 30 January 2025, use one of these formulas:.To move the date backwards, supply a negative number - the result will be a past date. To shift the date forward, use a positive number - the output will be a future date. For the months argument, provide an integer specifying how many months to add to or subtract from the start date.a reference to the cell containing the start date.a string enclosed in quotation marks, e.g.For the start_date argument, supply a valid Excel date in one of these forms:. To make a basic EDATE formula in Excel, follow these steps: To display the result as a date, apply a Date format of your choosing. By default, the EDATE function returns a serial number representing a date internally in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |