Hi

MS Weeknum ?!:-)
The function with 2nd parameter as 1 (US week system) returns week 53 for
dates 26. - 31.12.1999 (6 days) and week 1 for date 01.12.2000 (1 day). The
date 02.01.2000 belongs to week 2. With 2nd parameter set to 2 we get 5-day
week and 2-day week in time interval 27.12.1999 - 02.01.2000

What a crap! A week is by definition 7 days long! And doesn't have any
connection to year, we use, at all. I think it originates from celestial
calendar probably.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"John Britto" wrote in message
...
Dear All,
Good day,
I am using weeknum() function to get week number. But, there is a
difference between the computer generated weeknum and what is shown on a
real
calendar. Example, today is week 41 by weeknum(), but the calendar shows
week 40 (3 ~ 9 Oct). Why? Please...

On excel, if I enter a number on a cell it should calculate the product,
i.e. in a cell the value is 1000 (constant) and when I enter 5 it should
should automatically give 5000, if i enter 10, the result must be 10,000..
Is there any function or any manipulation method please...thanks