WEEKDAY
WEEKDAY
The weekday function returns a number from the date, that number (between 0 and 7) represents the day of the week. By default, WEEKDAY returns 1 for Sunday and 7 for Saturday. If we not specify any number, excel will use 1.
Weekday Function किसी date से number return करता है, वह नंबर सप्ताह के दिन को represent करता है जो 0 और 7 के बीच हो सकता है. Weekday return 1 for Sunday और 7 for Saturday. अगर हम नंबर नहीं specify करते हैं तो, एक्सेल 1 नंबर मानता है.
Syntax:-
=WEEKDAY(Date,Type)
Date : The date from which we want to get the day of week
return_type 1: Numbers 1-7 (Sunday through Saturday) – default
return_type 2: Numbers 1-7 (Monday through Sunday)
return_type 3: Numbers 0-6 (Monday through Sunday)
