[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Locale issue

Why Tea

12/19/2006 2:57:00 PM

The Month() function works for Month("Oct 2006") - gives a value of 10;
but it doesn't work if you happen to be in Sweden, you will need to use
Month("Okt 2006"). How do you overcome the problem with VBA? I would
like the locale of the worksheet to be any one of the English speaking
countries.

/Why Tea
4 Answers

Ron de Bruin

12/19/2006 4:34:00 PM

0

hi Why Tea

Using the month name is not possible
If you use a ISO date string it is working in all excel versions

=MONTH("2006-10-01")

More info about the ISO standard you can find here
http://www.rondebruin.nl/i...


--

Regards Ron de Bruin
http://www.rondebruin.n...


"Why Tea" <ytlim1@gmail.com> wrote in message news:1166540232.074510.53980@80g2000cwy.googlegroups.com...
> The Month() function works for Month("Oct 2006") - gives a value of 10;
> but it doesn't work if you happen to be in Sweden, you will need to use
> Month("Okt 2006"). How do you overcome the problem with VBA? I would
> like the locale of the worksheet to be any one of the English speaking
> countries.
>
> /Why Tea
>

Why Tea

12/19/2006 7:03:00 PM

0


Ron de Bruin wrote:
> hi Why Tea
>
> Using the month name is not possible
> If you use a ISO date string it is working in all excel versions
>
> =MONTH("2006-10-01")
>
> More info about the ISO standard you can find here
> http://www.rondebruin.nl/i...

Thanks Ron. Very informative Website too.

I need to use month name as the worksheet is meant for a monthly
report. Writing "2006-10-01" is not really the same as "Oct 2006". This
is especially the case when you are dealing with ISO weeks, as the
months don't always begin at the 1st.

Ron de Bruin

12/19/2006 9:21:00 PM

0

If you want to make a report from weeks or months maybe this add-in will help you
http://www.rondebruin.nl/easy...



"Why Tea" <ytlim1@gmail.com> wrote in message news:1166554965.371673.54460@a3g2000cwd.googlegroups.com...
>
> Ron de Bruin wrote:
>> hi Why Tea
>>
>> Using the month name is not possible
>> If you use a ISO date string it is working in all excel versions
>>
>> =MONTH("2006-10-01")
>>
>> More info about the ISO standard you can find here
>> http://www.rondebruin.nl/i...
>
> Thanks Ron. Very informative Website too.
>
> I need to use month name as the worksheet is meant for a monthly
> report. Writing "2006-10-01" is not really the same as "Oct 2006". This
> is especially the case when you are dealing with ISO weeks, as the
> months don't always begin at the 1st.
>

Why Tea

12/20/2006 10:27:00 AM

0


Ron de Bruin wrote:
> If you want to make a report from weeks or months maybe this add-in will help you
> http://www.rondebruin.nl/easy...
>

Thanks Ron. You sure have done many advanced stuff with Excel. Like
many international companies, there is always a need to do timesheets
and expense reports every month. Large companies use SAP and other
specialized tools. For not so big companies, it can be done
quick-n-dirty with Excel. Perhaps you have already done something
similar. I'd be interested to have a look.

What I have done is rather simple. For the timesheet, divide the year
in ISO weeks and then group them in months (vary from 4-6 weeks). The
month is selectable from a list, then the ISO weeks are written into
each cell. As for the expense report, there is an exchange rates with
an Update button, plus the usual stuff for expenses, etc.. I have been
learning Excel for only the past two weeks, I know there are many
things I can do better.

/Why Tea