The 12 multiplies

[proexcel]

Hello everyone

we are in 2017 year
pay 48 months (which is 4 years)

the question is how we can write formula in excel that each 12 months pass it is automatically go to another year for example when 12 months passed write 2018 and if 24 months passed write 2019?

thanks

 

[Simon4s]

Hello everyone

we are in 2017 year
pay 48 months (which is 4 years)

the question is how we can write formula in excel that each 12 months pass it is automatically go to another year for example when 12 months passed write 2018 and if 24 months passed write 2019?

thanks

=lookup(A1,{0,12,24},{2017,2018,2019})

 

[Joe4]

Take a look at the EDATE function.
This adds any number of months that you want to a valid date and returns the new data.
See here for details and descriptions: https://www.techonthenet.com/excel/formulas/edate.php

If this does solve your issue, please provide more details, like walk us through an actual data example that you have.