如何能将日期按照周来统计

pangdudu505

请教一下，我只能将日期转换为星期几，不知道怎么按照周来统计。一个月中有4周。帮忙解决，谢谢

whsfhwm

感觉可以直接采用公式来觉得此问题，似乎更简单哈。

pangdudu505

能帮忙演示一下吗,谢谢,我怎么没找到weeknum这个啊

pangdudu505

方漠

WEEKNUM   

Returns a number that indicates where the week falls numerically within a year.

Important   The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are incorrect according to the European standard.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.
Syntax

WEEKNUM(serial_num,return_type)

Serial_num   is a date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Return_type   is a number that determines on which day the week begins. The default is 1.

Return_type Week Begins
1 Week begins on Sunday. Weekdays are numbered 1 through 7.
2 Week begins on Monday. Weekdays are numbered 1 through 7.

Remark
Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Microsoft Excel for the Macintosh uses a different date system as its default.

Example

The example may be easier to understand if you copy it to a blank worksheet.

   

   A
1 Data
2 March 9, 2008
Formula Description (Result)
=WEEKNUM(A2,1) Number of the week in the year, with a week beginning on Sunday (11)
=WEEKNUM(A2,2) Number of the week in the year, with a week beginning on Monday (10)


Note  March 9, 2008 is a Sunday.

[此贴子已经被作者于2006-12-15 9:14:32编辑过]

仔V仔

请上传附件

或者可以用格式转换TEXT的形式来做

pangdudu505

有哪位好心的高手帮我解答一下

pangdudu505

主要是月，要是能按照年就更好了[em21]

[此贴子已经被作者于2006-12-12 18:23:30编辑过]

yaosap

按年还是按月计周数呢？

pangdudu505

以下是引用pangdudu505在2006-12-11 11:25:00的发言：