The EDATE function in Excel allows you to shift a date by a specified number of months, either into the future or the past. Here’s how it works:
-
Syntax:
EDATE(start_date, months)
start_date
: The initial date (a valid Excel date).months
: The number of months to add or subtract.
-
Examples:
- To find the date 6 months in the future from January 1, 2023, use:
(result: July 1, 2023).
- For a date 4 months ago from today, use:
(result: 4 months before the current date).
- To find the date 6 months in the future from January 1, 2023, use:
-
Additional Scenarios:
- To move by years, multiply the number of years by 12 (e.g., forward 2 years:
).
- EDATE maintains end-of-month dates (e.g.,
returns February 28, 2019).
- Leap years are respected (e.g.,
returns February 29, 2020).
- To move by years, multiply the number of years by 12 (e.g., forward 2 years:
Remember, EDATE is versatile for various date-related calculations!
No comments:
Post a Comment