Hi
If I have a contract term of 5 years, ie 60 months, how do I create a vba code which would generate 60 rows using formula and indicating the respective months and have it formatted in (Mmm-YY)? I could use eomonth formula but it would be tedious and manual
For example:
Contract Term = 60 months (Cell 1)
Billing date = Oct21 (Cell 2)
Billing Months = Nov21 - Oct26 (Cell 3 - Cell 61)
Thanks in advance! Sorry, am not sure why I am not able to upload an excel attachment
[ATTACH]753115
Bookmarks