Hello
i have this formula, which I want to distribute to my team so that they can use it as a normal formula.
Basically the formula converts week number to period. E.g. first 4 weeks are period 1, next 4 weeks are period 2 and like wise. It also gives me week from that period.
e.g. 10/2/2014 which is week 40 falls on 10 period and week number is 4 so my output is "10X4". Yes I need that X thing between to differentiate period and week.I tried but failed.
Also I cannot use it on other files. Is there anyway to use it on all the files in excel.
Please help and how can I convert this to function.
i have this formula, which I want to distribute to my team so that they can use it as a normal formula.
Code:
=IF(ROUNDUP(((WEEKNUM(D66))/4),0) >13,13,ROUNDUP(((WEEKNUM(D66))/4),0) ) &"X"&ABS((ROUNDUP(((WEEKNUM(D66))/4),0))-((WEEKNUM(D66))/4)-1)/25*100
e.g. 10/2/2014 which is week 40 falls on 10 period and week number is 4 so my output is "10X4". Yes I need that X thing between to differentiate period and week.I tried but failed.
Also I cannot use it on other files. Is there anyway to use it on all the files in excel.
Please help and how can I convert this to function.