In the tutorial below, the instructor mentions he can show us how to populate the the amount of months depending the year cell value.
https://www.youtube.com/watch?v=20ycC_GY56Y
Thanks!
In the tutorial below, the instructor mentions he can show us how to populate the the amount of months depending the year cell value.
https://www.youtube.com/watch?v=20ycC_GY56Y
Thanks!
Hi Alex and welcome to the Forum
I haven't watched the video but the number of months for (whole) number of years is simply that number * 12.
If you have a fractional number of years in cell H5 say, this formula will give the (rounded-down) number of months
=ROUNDDOWN(H5*12,0)