how to build a function in vba that will take an input an array of values like from 1,2,3 n give 1,1.5,2,2.5,3 depending on a given frequency.
for example if i what the table to split to semi annual dates it will go from 1-2yrs to 0.5yr, 1yr, 1.5yrs, 2yrs. etc
Bookmarks