writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 45:
Line 45: − + − + − + − +
no edit summary
| class=" " |
| class=" " |
|}
|}
</div>
=WEEKDAY(A1): Calculates the 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 the 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'. Displays '''3''' (i.e. Wednesday) as a result.
=WEEKDAY(DATE(2013,10,28),3) : Calculates the 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'. Displays '''0''' (i.e. Monday) as a result.
== See Also ==
== See Also ==