writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 47:
Line 47: − + − + + + + +
no edit summary
=WEEKDAY(A1): Calculates day of the week from date mentioned in A1. Displays '''4''' (i.e. Wednesday) as a result.
=WEEKDAY(A1): Calculates day of the week from date mentioned in A1. Displays '''4''' (i.e. Wednesday) as a result.
=WEEKDAY(A1,2): Calculates day of the week from date mentioned in A1 and return type '2'. Displays '''3''' (i.e. Wednesday) as a result.
=WEEKDAY(A1,2): Calculates day of the week from date mentioned in A1 and return type '2'. <br />Displays '''3''' (i.e. Wednesday) as a result.
=WEEKDAY(DATE(2013,10,28),3) : Calculates day of the week from date mentioned and return type '3'. Displays '''0''' (i.e. Monday) as a result.
=WEEKDAY(DATE(2013,10,28),3) : Calculates day of the week from date mentioned and return type '3'. <br />Displays '''0''' (i.e. Monday) as a result.
==Related Videos==
{{#ev:youtube|GnlrbZytkmY|280|center|WEEKDAY}}
== See Also ==
== See Also ==