Има ли разлика между №2 и №11?
При избора на начало на седмицата във функцията weekday има ли значение дали се избере 2 или 11? На пръв поглед и двете дават един резултат, но надали е точно така?
В Help-а на ексел за "WEEKDAY function" има обяснения за различните стойности на параметрите, както и пример.
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.
If serial_number is out of range for the current date base value, a #NUM! error is returned.
If return_type is out of the range specified in the table above, a #NUM! error is returned.
Return_type
Number returned
1 or omitted
Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel.
2
Numbers 1 (Monday) through 7 (Sunday).
3
Numbers 0 (Monday) through 6 (Sunday).
11
Numbers 1 (Monday) through 7 (Sunday).
12
Numbers 1 (Tuesday) through 7 (Monday).
13
Numbers 1 (Wednesday) through 7 (Tuesday).
14
Numbers 1 (Thursday) through 7 (Wednesday).
15
Numbers 1 (Friday) through 7 (Thursday).
16
Numbers 1 (Saturday) through 7 (Friday).
17
Numbers 1 (Sunday) through 7 (Saturday).
Благодаря ти, Дарина, но и 2, и 11 показват
В новата версия, параметрите на функцията са повече и това е свързано с изискванията на фирмите за представяне на седмични отчети. Дните в седмицата могат да опишат различни "стилове" на седмица - започваща от понеделник, или от неделя, или от всеки друг ден на седмицата и завършващи след 7 дни. Явно традиционно се използват само параметри 1, 2 и 3.
Weekly Reporting and the WEEKDAY Function
I’ve only used the WEEKDAY Function with regards to reporting data, and then only sporadically.
Companies normally have weekly reporting requirements. However, while every week has seven days, there are two important distinctions. First is the start and end days of each week. Some companies use a Sunday-Saturday week, others a Monday-Sunday. These two are the most common, although I came across one company that had a Saturday-Friday reporting week.
The second distinction in weekly reporting is what day is used to represent the entire week. In the USA it’s common to use a week-ending date for weekly reports, while in Europe a week-commencing date is used quite frequently.
I won’t go into specific uses of the WEEKDAY Function for reporting in this post, but the two distinctions mentioned for weekly reporting make it a handy function to know.
Вашият отговор
