This beginner’s guide explains how you can find the weekday, workday in LibreOffice Calc.
LibreOffice Calc has dedicated functions that you can use to find out the weekday, the number of weekdays, etc. Using these in the formula and combining them, you can solve many problems and calculate different things. Let’s see how they work.
Table of Contents
Weekday and Workday
Weekday function
The WEEKDAY function in Calc returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. The number depends on the type. See below.
Syntax
=WEEKDAY(date, type)
- date: Any date format as your Calc settings. For example, mm/dd/yyyy; dd/mm/yyyy; “dd-mm-yyyy”.
- type: Valid values are 1, 2, and 3. Default is 1. Based on type, values are below.
| weekday | type=1 | type=2 | type=3 |
| Sunday | 1 | 7 | 6 |
| Monday | 2 | 1 | 0 |
| Tuesday | 3 | 2 | 1 |
| Wednesday | 4 | 3 | 2 |
| Thursday | 5 | 4 | 3 |
| Friday | 6 | 5 | 4 |
| Saturday | 7 | 6 | 5 |
Example
1. The following example returns 4 as it is April 7, 2021 which is Wednesday. Because the type is 1 as default.
=WEEKDAY(04/07/2021)
2. You can also find out the day of the week using weekday as below. It is super handy to find out the day’s name. Actually, there are two ways to find this out. Using TEXT() and CHOOSE() function. See below.
=CHOOSE(WEEKDAY(D2),"sun","mon","tue","wed","thu","fri","sat")
Using Text function with custom formatting for Day as “dddd” you can also get the day name.
=TEXT(D2,"dddd")
Workday Function
Syntax
WORKDAY(StartDate; Days [; Holidays])
Example
This function returns the date number from the start date, with days passed excluding Saturdays, Sundays, and holidays (if included). Holidays are optional. For example, in the below image, 4/13 is returned, which is 3 days after 4/7, excluding 4/9 (holiday), 4/10, and 4/11. The function returns a number, and you need to apply cell formatting to Date. The StartDate is included in the count of Days if it is a workday.
=WORKDAY(D2,D3,D4)
Networkdays function
Syntax
NETWORKDAYS(StartDate; EndDate [; [ Holidays ] [; Workdays ] ])
Example
This function returns the total number of days starting from StartDate until EndDate excluding Holidays, Saturdays and Sundays. Additional Workdays can be included via an optional parameter. The StartDate and EndDate are included in the count if it is not weekends. For example, below, the total number of work days is 20 for the entire month of April 2021, with two holidays given.
=NETWORKDAYS(D2,D3,D4:E4)
Usage Notes
- WORKDAY, NETWORKDAYS are part of Open Document Standard specification (ODF) – ISO/IEC 26300:2-2015. Hence it should be followed by major office suites. Link to ODF file.
- Official documentation –
I hope this guide helps you to find out the weekday, and workday in LibreOffice Calc. If you have any questions, or comments mention them in the comment box below.