Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA functions
hello,
VBA functions EOMONTH and EDATE don't work in russian version of Excel, what can i do to improve situations? I should use english version of functions, not russian, because in our net some comps are with russian MS Office, some are - with russian. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA functions
"Natalia" wrote in message
... hello, VBA functions EOMONTH and EDATE don't work in russian version of Excel, what can i do to improve situations? I should use english version of functions, not russian, because in our net some comps are with russian MS Office, some are - with russian. Thank you Do the Russian versions have the Analysis ToolPak installed? You are likely better off developing with English version. If the functions are not available in the Russian version, then you will need to create equivalent functions for use in the Russian version. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA functions
Natalia
You can do as follows: Your_EDATE=DATE(YEAR(Date),MONTH(Date)+N_Months,DA Y(Date)) Where "N_Months" is the number of months ahead, so it is 5 it will give the date in 5 months' time. And: Your_EOMONTH =DATE(YEAR(Date),MONTH(Date)+(N_Months+1),0) Where "N_Months" is the number of months ahead, so if it is 5 it will give the end of month in 5 months' time. -- Robert Author of RibbonX: Customizing the Office 2007 Ribbon: LATEST INTERACTIVE TUTORIAL: http://www.msofficegurus.com/videos/...p_HT_Chart.asp FORUM: http://www.msofficegurus.com/forum/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
excel functions and User defined functions | Excel Programming |