Tired if this & found some online solution but none of them solve my problem.
If A1=Date (any date like 14 March 2016)
C1=No. Of Month (Like 5 or
& my excel has fixed Jan to Dec, 12 columns for current year.
So i need a formula which can populate Monthly Amount from March to July (if C1 is 5, irrespective of date)