Use WORKDAYS, NETWORKDAYS, SEQUENCE, ARRAYFORMULA in Sheets to build workdays with single formula

Google Sheets Tutorials · Intermediate ·🍎 Teaching & Learning Design ·1y ago

About this lesson

@redtailfanschool In this video we demonstrate how to build a single formula to show the working days in a data range, excluding the holidays. This is handy to create a column of workdays based on a start and end date. This can work in an attendance sheet for teachers to build the school days with a single formula.

Original Description

@redtailfanschool In this video we demonstrate how to build a single formula to show the working days in a data range, excluding the holidays. This is handy to create a column of workdays based on a start and end date. This can work in an attendance sheet for teachers to build the school days with a single formula.

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Related Reads

EdTech Blogs vs. Vlogs: Which Helps People Learn Better?

Discover how EdTech blogs and vlogs impact learning outcomes and which format is more effective for knowledge retention

Medium · Deep Learning

The Mission Behind Anitha Rises: Empowering Students, Women, and Lifelong Learners

Anitha Rises empowers students, women, and lifelong learners by providing visibility and confidence to succeed in the digital world, which matters for career growth and personal development

Dev.to · Anitha

Why Marks Alone Are a Terrible Measure of Progress

Learn why relying solely on marks is a flawed measure of student progress and how to implement more effective assessment methods

Dev.to · jahnavi sharma

2–2–1: On Student Accountability and Punctuality.

Learn how student accountability and punctuality impact academic success and why developing these habits matters

Medium · Deep Learning

5 Executive Functioning Strategies Every K-2 Teacher Needs: How to Teach Executive Functioning

Susan Jones Teaching