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