Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm having problems with EOMONTH
Hi Everyone,
I'm creating for a company, a daily report using excel. This report is going to be use by clients with differents language version of Excel (Spanish, English) or differents language version of Windows. Functions like: TODAY or NOW, works perfectly no matter what language version of excel i'm working with. It's seems that Excel recognize the function in the sheet and automatically convert that function to the local language version of excel (or Windows). However, EOMONTH (another functions i'm dealing with) doesn't works when i try to open the report in a spanish version of Excel. If I change the function to FIN.MES (spanish version of EOMONTH) to solve the problem, it works perfectly, but when I try to open the report in an english version of excel again, the function doesn't works. It seems that excel doesn't recognize the language of this functions. Can anyone of you help me with this? In Both versions, I have checked the Analisys ToolPak Excel Add-in Option. Regards, -- Ronni T. Vasquez M. |
#2
|
|||
|
|||
Instead of using ATP functions, you can use the built-in DATE() function
to do the same thing. For instance, instead of =EOMONTH(A1,1) you can use =DATE(YEAR(A1),MONTH(A1)+2,0) since the 0th day of the month is always the last day of the previous month. In article , "Ronni T. Vasquez M." wrote: Can anyone of you help me with this? |
#3
|
|||
|
|||
Hi,
Thanks a lot for your help!!! You were right!!! It worked!!! Regards, -- Ronni T. Vasquez M. "JE McGimpsey" wrote in message ... Instead of using ATP functions, you can use the built-in DATE() function to do the same thing. For instance, instead of =EOMONTH(A1,1) you can use =DATE(YEAR(A1),MONTH(A1)+2,0) since the 0th day of the month is always the last day of the previous month. In article , "Ronni T. Vasquez M." wrote: Can anyone of you help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
symbol for divison problems; divison formula | Excel Discussion (Misc queries) | |||
Problems with "hyster-grams" :-) | Excel Discussion (Misc queries) | |||
Excel Analysis Add-in EOMONTH generates #NAME? error | Excel Worksheet Functions | |||
How about adding a quarterly function to Excel like its EOMonth? | Excel Worksheet Functions | |||
I am having problems creating pivot table of data | Charts and Charting in Excel |