Office中国论坛/Access中国论坛

标题: 如何能将日期按照周来统计 [打印本页]

作者: pangdudu505 时间: 2006-12-11 19:14
标题: 如何能将日期按照周来统计
请教一下，我只能将日期转换为星期几，不知道怎么按照周来统计。一个月中有4周。帮忙解决，谢谢

作者: pangdudu505 时间: 2006-12-11 19:25

以下是引用pangdudu505在2006-12-11 11:14:00的发言：
请教一下，我只能将日期转换为星期几，不知道怎么按照周来统计。一个月中有4周。帮忙解决，谢谢

作者: pangdudu505 时间: 2006-12-12 05:06

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

作者: yaosap 时间: 2006-12-12 16:01
按年还是按月计周数呢？

作者: pangdudu505 时间: 2006-12-13 02:22
主要是月，要是能按照年就更好了[em21]

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

作者: pangdudu505 时间: 2006-12-14 18:16
有哪位好心的高手帮我解答一下

作者: 仔V仔 时间: 2006-12-14 19:26
请上传附件

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

作者: 方漠 时间: 2006-12-15 17:10
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编辑过]

作者: pangdudu505 时间: 2006-12-16 22:38
[attach]22151[/attach]

作者: pangdudu505 时间: 2006-12-16 22:39
能帮忙演示一下吗,谢谢,我怎么没找到weeknum这个啊

作者: whsfhwm 时间: 2006-12-18 06:55
感觉可以直接采用公式来觉得此问题，似乎更简单哈。

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)