Hi Adam,
Great question! There is actually a simpler way to add partial months to a date in Excel. You can use the
EDATE function, which allows you to add a specified number of months to a date, including partial months.
Here's the formula you can use:
- =EDATE(B27,S21)
In this formula,
B27 is the date you want to add months to, and
S21 is the number of months you want to add. You can enter a decimal value for
S21 to add partial months.
For example, if you want to add 1.5 months to the date in cell B27, you can use the formula:
- =EDATE(B27,1.5)
This will add one month and 15 days to the date in cell B27.