Hallo GMc

Zie deze pagina
http://office.microsoft.com/nl-nl/ex...581001043.aspx

En ook
http://www.rondebruin.nl/atp.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"GMc" wrote in message ...
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