![]() 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 |