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

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

Oops, this is no Dutch group <g

Hi GMc

See this page
http://msdn.microsoft.com/en-us/library/bb277364.aspx
Or the pages on my site

http://www.rondebruin.nl/isodate.htm
And
http://www.rondebruin.nl/weeknumber.htm


And also
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

I have the same issue as you do. I have an excel file that is an excel 97/2003 file. Some people open the file in excel 2007. The calculation (formula) sometimes disappears and becomes =#NA. In that cell i just have =weeknum(A1).

Does anyone know why the formula gets replaced? This is reallly a pain because i have to put back the formula



GMc wrote:

Weeknum Issue
14-Jun-08

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

Previous Posts In This Thread:

On Thursday, June 12, 2008 4:49 PM
Ron de Bruin wrote:

Weeknum Issue
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

On Thursday, June 12, 2008 4:52 PM
Ron de Bruin wrote:

Weeknum Issue
Oops, this is no Dutch group <g

Hi GMc

See this page
http://msdn.microsoft.com/en-us/library/bb277364.aspx
Or the pages on my site

http://www.rondebruin.nl/isodate.htm
And
http://www.rondebruin.nl/weeknumber.htm


And also
http://www.rondebruin.nl/atp.htm


--

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


"GMc" wrote in message ...

On Saturday, June 14, 2008 3:58 PM
GMc wrote:

Weeknum Issue
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


Submitted via EggHeadCafe - Software Developer Portal of Choice
Adding WCF Service References
http://www.eggheadcafe.com/tutorials...ce-refere.aspx