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.