/

Find out Weekday, Workday in LibreOffice Calc

390 views

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, 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.

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.
weekdaytype=1type=2type=3
Sunday176
Monday21
Tuesday321
Wednesday432
Thursday543
Friday654
Saturday765

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)
Simple Weekday function
Simple Weekday function

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")
Choose function
Choose function

Using Text function with custom formatting for Day as “dddd” you can also get the day name.

=TEXT(D2,"dddd")
Text Function
Text Function

Workday Function

Syntax

WORKDAY(StartDate; Days [; Holidays])

Example

SEE ALSO:  Date and Time Formats in LibreOffice Calc

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 this 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)
WORKDAY example
WORKDAY example

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 optional parameter. The StartDate and EndDate is included in teh count if it is not weekends. For example below, total number of work days is 20 for entire month of April 2021 with two holidays given.

=NETWORKDAYS(D2,D3,D4:E4)
NETWORKDAYS Example
NETWORKDAYS Example

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 –
  1. WEEKDAY
  2. WORKDAY
  3. NETWORKDAYS

I hope this guide helps you to find out the weekday, workday in LibreOffice Calc. If you have any questions, comments mention them in the comment box below.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

IT professional by profession and founder of libreofficehelp.com. Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.