|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 12th, 2008, 09:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
June 12th, 2008, 09:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 "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
|
|
#3
June 12th, 2008, 09:52 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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
|
|
#4
March 22nd, 2010, 05:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weeknum issue
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
