Create a list of working days - Excel WORKDAY function
Learn how to quickly create a list of working days only. Exclude Saturday, Sunday, Public Holidays and any other day that you like. Covers creating a list of working days, with and without formulas.
Timing Stamps:
@ 00:00 Excel how to create business days only
@ 00:51 Option #1: Excel create a list of working days only using AutoFill
@ 02:25 Option #2: Excel list all working days only using the WORKDAY function
@ 03:30 Option #3: Excel create a list of weekdays only, and exclude Holidays too
👀 Read the full blog post here: https://excelatwork.co.nz/2013/11/02/excel-how-can-i-create-a-list-of-weekdays-only/
🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/ 🔔
❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.
#ExcelTutorial #ExcelTips #ExcelIntermediate #ExcelatWork
Видео Create a list of working days - Excel WORKDAY function канала Excel at Work
Timing Stamps:
@ 00:00 Excel how to create business days only
@ 00:51 Option #1: Excel create a list of working days only using AutoFill
@ 02:25 Option #2: Excel list all working days only using the WORKDAY function
@ 03:30 Option #3: Excel create a list of weekdays only, and exclude Holidays too
👀 Read the full blog post here: https://excelatwork.co.nz/2013/11/02/excel-how-can-i-create-a-list-of-weekdays-only/
🔔 Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/ 🔔
❤ VERSION FRIENDLY ❤
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.
#ExcelTutorial #ExcelTips #ExcelIntermediate #ExcelatWork
Видео Create a list of working days - Excel WORKDAY function канала Excel at Work
excel create a list of business days only excel list of working days only excel how to create business days only excel create list of working days excel list all working days how do I create a list of working days in excel how can i create a list of weekdays only excel create a list of working days only excel list of business days only how to get a list of working days in excel list of working days excel excel list of working days excel workday function
Комментарии отсутствуют
Информация о видео
2 июня 2021 г. 19:00:21
00:05:41
Другие видео канала
FILL BLANK CELLS With VALUE ABOVE In Excel Normal Range + Pivot Table
How To Have MULTIPLE FILTERS Per Field In A PIVOT TABLE - Excel Tutorial
How to Create DROP DOWN LIST in Excel cell
CHANGE DATE FORMAT in Excel | Convert to CORRECT DATE, Abbreviate Dates
Delete last page of legal pleading without line numbering disappearing
EXCEL Worksheets View SIDE BY SIDE
Shortcuts To MOVE Paragraph In WORD #shorts
Formula for FINDING AVERAGE in Excel
Excel Shortcut Tips using Ctrl + A #shorts
How To Use SUM Function In Excel: The Go-To Totalling Formula you NEED to KNOW!
How to APPLY FILTER in Excel STEP BY STEP
Shortcut Move Columns and Rows in Excel Effortlessly #shorts
How To Fill SERIES OF DATES in Excel DAYS, WEEKS, MONTHS and YEARS
Welcome to Excel at Work!
Word Tables - Quick and Easy Tip to Move Table Rows Effortlessly #shorts
SUMPRODUCT Excel (Including 3 Examples)
EXCEL: How to Repeat Column A on Every Page
How to Remove Excel #DIV/0 Error
Excel Count Cells with Text (Cells that Include Text, Only Text and Occurrence of Specific Text)
HOW TO Freeze a Row in Excel (inc. Freeze Multiple Rows and Columns)
