I have a 2003 .xls file that I run on 2007, there is a formula in the
file that uses the =weeknum(c2) formula. I am getting an issue where
excel is removing this formula and replacing it with =#n/a, which
means I have to go in and add the formula again.

This is not the first time this has happened, I had another completely
independant file where the same thing happened with the weeknum
formula.

A couple of things

1) does anyone know whats going on ?

2) is there any other easy way to extract a workweek from a date
without using this formula.

Thanks

GMc