Hi --

I have a file in which people input start date and duration (i.e. # of months, in .5 increments -- so it could be 4 or 5.5, for instance).

From this basic data, I'm hoping to be able to calulate the end date, rounded to the half month (half month could be defined as the 15th, i dont mind).

For instance, if something has a start date of 4/13/2018 and a duration of 2, then the end date should be something like 6/15/2018. Or, if the duration was 2.5, the end date should be 6/30/2018.

Another example is if someone put a start date of 3/25/2018 and a duration of 2, I'd like for the end date to show 5/31/2018.

*IF* it's easier to do w/o the rounding to the half month, that is fine as well.
(Bonus points if you have a formula for each method)

Is this possible?

Thank you!