Formulas and Functions
ఈ కంట్రో‌ల్‌ను మారిస్తే, ఈ పేజీ ఆటోమేటిక్‌గా అప్‌డేట్ చేయబడుతుంది

WEEKNUM

The WEEKNUM function returns the number of the week within the year for a given date/time value or date string.

WEEKNUM(date, first-day)

date: A date/time value or date string.

first-day: An optional modal value that specifies whether weeks should begin on Sunday or Monday.

Sunday is 1 (1 or omitted): Sunday is the first day (day 1) of the week and Saturday is day 7.

Monday is 1 (2): Monday is the first day (day 1) of the week and Sunday is day 7.

Example

=WEEKNUM("12/7/2009",1) returns 29, if Sunday is considered the first day of the week.

=WEEKNUM("12/7/2009",2) returns 28, if Monday is considered.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ఉపయోగకరంగా ఉందా?
అక్షరాల పరిమితి: 250
అక్షరాల గరిష్ట పరిమితి 250.
మీ ఫీడ్‌బ్యాక్ అందించినందుకు ధన్యవాదాలు.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.