Hi All
I have data in excel which I need a formaula which calculates the year to date position when a month number is changed. for example
Month
Jan Feb March April..... Dec
5 4 2 3 4
In a input box in excel cell (E4)
if 1 is entered into the box it would return 4 (jan)
if 2 is entered into the box it would return 9 (jan + feb)
...
if 4 is entered into the box it woulld return 14 (jan + feb+mar+april)
Thanks
Hope you can help
Bookmarks