Hi all
I'm using the formula " ="W."& WEEKNUM(M20,1)" to calculate number of week and return the result W. Weekno.
However, i have to double click to this cell and press enter to get the result, or else the cell would display #Name ?
Can you help to give me the solution
Thanx much
Bookmarks