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!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to Autopopulate the amount of Months from a Year Cell
0
Discussion
Please attach your workbook (or a copy of it from which private data were removed) to your qestion and rephrase your question to say which cell you want to fill with which data. You can do all of that in Edit mode.
Variatus (rep: 4889) Jan 30, '21 at 7:24 pm
Answers
0
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)