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.