Function weeknum #N/A

[benliaw]

I have a problem with the function weeknum.

In the merged cell A4:B4 I have a date field which is formated to display "Dated : "dd mmmm yyyy. In the merged cell A2:E2, I have the function =weeknum(A4-4) with a cell format "Week "0.

My problem is that recently, after I've emailed the file to my friend, I get an error when I open the file "File error: data may have been lost." I could only click on OK.

In my merged cell A2:E2, it still display Week 11 but I lost my function in the cell. The function would show =#N/A and if I go to A2:E2 and do F2 Enter, the cell would change from Week 11 to #N/A.

I did not have problem with this before and I've been having this formula since 2007. This problem started recently, only in the month of March 2009.

I would appreciate it if someone could help me.

 

[Sandeep Warrier]

Check if you have Analysis Tool Pack enabled as an Add-In.

If you do, then check if the formula works on a new sheet. If it works on a new sheet it may mean that your original sheet has somehow been corrupted.