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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |