Calculating a future date based on months

[BELLABLUMOJO]

Hello,

I am trying to develop a formula that will calculate a future date based on months.

12 mths = 365 Days
6 mths = 183 days
3 mths = 91 days

Can anyone assist with this, I have tried sumif & sum ifs & just cant get there.

Thank you

[Adtxc]

=edate(a4,b4)

[Gregb11]

Does it have to be those exact number of days? You can use EDATE to get the new dates. In C4 you could use:

=EDATE(A4,B4)

copy down.

[BELLABLUMOJO]

Thanks - that works great