weekday

Previous chapterNext chapter Show allShow all    Hide allHide all

The function weekday (date) calculates the weekday from a date value.

Syntax: =weekday(date)

value

weekday

1

Sunday

2

Monday

3

Tuesday

4

Wednesday

5

Thursday

6

Friday

7

Saturday

Result format: integer

Example Example

=now() with format string "hh:mm:ss dd/mm/yy" is 12:46:24 05.06.01
Cell A2= day(A1) is 3