Formulas and Functions
இந்தக் கட்டுப்பாட்டை மாற்றினால் இந்தப் பக்கம் தானாக மாற்றப்படும்

WEEKDAY

The WEEKDAY function returns a number that is the day of the week for a given date/time value or date string.

WEEKDAY(date, first-day)

date: A date value or date string.

first-day: An optional modal value that specifies how days are numbered.

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.

Monday is 0 (3): Monday is the first day (day 0) of the week and Sunday is day 6.

Examples

=WEEKDAY("6 Apr 1988",1) returns 4 (Wednesday, the fourth day if you start counting from Sunday as day 1).

=WEEKDAY("6 Apr 1988") returns 4, the same value as the preceding example (numbering scheme 1 is used if no number-scheme argument is specified).

=WEEKDAY("6 Apr 1988",2) returns 3 (Wednesday, the third day if you start counting from Monday as day 1).

=WEEKDAY("6 Apr 1988",3) returns 2 (Wednesday, if you start counting from Monday as day 0).

See alsoDAYNAME
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.