Home |
Search |
Today's Posts |
#1
|
|||
|
|||
weeknumber
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to get the current weeknumber | Excel Discussion (Misc queries) | |||
Weeknumber in Excel | Excel Discussion (Misc queries) | |||
Wrong weeknumber 2004 / 2005 | Excel Discussion (Misc queries) |