Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
I have built spreadsheets in Excel 2003 using the EOMONTH formula with no
problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
You could replace the eomonth formulas with functions not from the Analysis
ToolPak Can you post an example -- Regards, Peo Sjoblom "Duke" wrote in message ... I have built spreadsheets in Excel 2003 using the EOMONTH formula with no problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
Thanks, an example would be
EOMONTH($B$1,-1), where b1 is 4/25/08 and I want to know the date for the end of the month prior to 4/25/08 -- Duke "Peo Sjoblom" wrote: You could replace the eomonth formulas with functions not from the Analysis ToolPak Can you post an example -- Regards, Peo Sjoblom "Duke" wrote in message ... I have built spreadsheets in Excel 2003 using the EOMONTH formula with no problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
I've seen this problem mentioned in these forums "a lot". I've not
experienced it (yet!). A non-ATP replacement for: =EOMONTH($B$1,-1) =B1-DAY(B1) Format as Date -- Biff Microsoft Excel MVP "Duke" wrote in message ... Thanks, an example would be EOMONTH($B$1,-1), where b1 is 4/25/08 and I want to know the date for the end of the month prior to 4/25/08 -- Duke "Peo Sjoblom" wrote: You could replace the eomonth formulas with functions not from the Analysis ToolPak Can you post an example -- Regards, Peo Sjoblom "Duke" wrote in message ... I have built spreadsheets in Excel 2003 using the EOMONTH formula with no problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
Thanks
-- Duke "T. Valko" wrote: I've seen this problem mentioned in these forums "a lot". I've not experienced it (yet!). A non-ATP replacement for: =EOMONTH($B$1,-1) =B1-DAY(B1) Format as Date -- Biff Microsoft Excel MVP "Duke" wrote in message ... Thanks, an example would be EOMONTH($B$1,-1), where b1 is 4/25/08 and I want to know the date for the end of the month prior to 4/25/08 -- Duke "Peo Sjoblom" wrote: You could replace the eomonth formulas with functions not from the Analysis ToolPak Can you post an example -- Regards, Peo Sjoblom "Duke" wrote in message ... I have built spreadsheets in Excel 2003 using the EOMONTH formula with no problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EOMONTH formula randomly converts to NA
You're welcome!
-- Biff Microsoft Excel MVP "Duke" wrote in message ... Thanks -- Duke "T. Valko" wrote: I've seen this problem mentioned in these forums "a lot". I've not experienced it (yet!). A non-ATP replacement for: =EOMONTH($B$1,-1) =B1-DAY(B1) Format as Date -- Biff Microsoft Excel MVP "Duke" wrote in message ... Thanks, an example would be EOMONTH($B$1,-1), where b1 is 4/25/08 and I want to know the date for the end of the month prior to 4/25/08 -- Duke "Peo Sjoblom" wrote: You could replace the eomonth formulas with functions not from the Analysis ToolPak Can you post an example -- Regards, Peo Sjoblom "Duke" wrote in message ... I have built spreadsheets in Excel 2003 using the EOMONTH formula with no problems. I am now using 2007 but sometimes have to send the work to people in 2003 format. THe problem is that the EOMONTH formulas randomly convert. That is the speadsheet may work fine for months, then the formula will be replaced with NA. Has anyone else seen this and are there any suggestions or fixes. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EOMONTH Formula | Excel Worksheet Functions | |||
Formula Disappears, converts to a value | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) |