Excel: Add dates skipping weekends
Skip Weekends: Smart Date Adding in Excel
Learn how to add a number of days to a date in Excel and, at the same time, skip weekends. The formula I will show you adds days to dates but ensures that weekend dates that fall into the period are excluded from the count. This is very useful for project management and other situations where you need to make calculations of time but where weekend days are not relevant.
VIEW MORE VIDEOS JUST LIKE THIS ON MY YOUTUBE CHANNEL
Microsoft Office ► / @mastermicrosoftoffice
TIP ME TO SAY THANK YOU? ► paypal.me/projectwoman
IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
Excel - Chart Title From Cell's Contents ► • Excel - Chart Title From Cell's Conte...
Excel - Adjust Margins to Print More on a Page ► • Excel - Adjust Margins to Print More ...
Excel - Chart Attached to Table Auto-updates ► • Excel - Chart Attached to Table Auto-...
Excel - Format Data Super Quick & Super Easy ► • Excel - Format Data Super Quick & Sup...
Excel Adjust Column Widths Quickly & Easily ► • Shorts
Excel - Format Data as a Table ► • Excel - 1 Click Data Format #Shorts
Excel Hide Gridlines When Printing ► • Excel Hide Lines When Printing #Shorts
Excel Instant Calculations on the Status Bar - Answers without Formulas ► • Excel Instant Calculations on the Sta...
Excel Quickly Adjust Row Heights - Auto Resize or Manual ► • Excel Quickly Adjust Row Heights - Au...
Excel Navigate Worksheet Tabs in Big Workbooks - Quick & Easy ► • Excel View All Worksheet Tabs in Big ...
Excel Insert Column as you Move Data - Automatically Make Room for Data ► • Excel Auto-Add Column as you Move Dat...
Excel Stop Printing Empty Pages - Solve Print Problems with Page Break Preview ► • Excel Stop Printing Empty Pages - Sol...
Excel Trick: Avoid Scientific Notation for Long Numbers ► • Excel Trick: Avoid Scientific Notatio...
Excel Remove Table Filter Buttons - Clean Up a Table ► • Excel Remove Table Filter Buttons - C...
Excel Button Navigation - Quick & Easy Macro Free Solution ► • Excel Button Navigation - Quick & Eas...
Excel hack: Uppercase to Proper Case in Seconds ► • Excel hack: Uppercase to Proper Case ...
One Keystroke to Jump to Last Filled Row in Excel ► • One Keystroke to Jump to Last Filled ...
Excel Formula for the Last Value in a Column ► • Excel Formula for the Last Value in a...
Excel trick: Split Data into Columns Without Typing ► • Excel trick: Split Data into Columns ...
Excel Hack: Enter Data in Multiple Cells Instantly ► • Excel Hack: Enter Data in Multiple Ce...
Autofill Like a Pro: Excel Data Filling Tip ► • Autofill Like a Pro: Excel Data Filli...
Zero Clutter - Hide Zeros in Excel Sheets ► • Zero Clutter - Hide Zeros in Excel Sh...
Excel Loan Calculations Made Easy ► • Excel Loan Calculations Made Easy #sh...
Excel Magic - Hide Data in Plain Sight ► • Excel Magic - Hide Data in Plain Sigh...
Excel Data Fusion - Join Columns in Seconds! ► • Excel Data Fusion - Join Columns in S...
Excel Hack: Sort Names Like a Pro ► • Excel Hack: Sort Names Like a Pro #sh...
Ultimate Age Calculation Hack in Excel ► • Ultimate Age Calculation Hack in Exce...
Excel Date Picker Magic: Save Time with a Clickable Calendar ► • Excel Date Picker Magic: Save Time wi...
Reverse Bar Chart Plotting Order in a Snap! Excel Quick Tip ► • Reverse Bar Chart Plotting Order in a...
What to do when Increase Decimals Doesn't Work in Excel ► • What to do when Increase Decimals Doe...
Word don’t spell check selected text ► • Word Hacks: Prevent Spell Check on Sp...
Stop the Frustration: How to Paste Data with Column Widths in Excel ► • Stop the Frustration: Paste Data with...
From Chaos to Order: Reverse an Unsorted List in Excel ► • From Chaos to Order: Reverse an Unsor...
Excel Chart Flip 101: Flip a Plot from Right to Left ► • Excel Chart Flip 101: Flip a Plot fro...
Fix First Column for Always Visible Row Headings ► • Fix First Column for Always Visible R...
Create Perfect Square Grids in Excel in Seconds! ► • Create Perfect Square Grids in Excel ...
Excel Screen Cleanup: Hide Annoying On-Screen Page Breaks ► • Excel Screen Cleanup: Hide Annoying D...
Excel Mastery: Create JPG from Range without Leaving Excel! ► • Excel Mastery: Create JPG from Range ...
Make Each Chart Bar Pop with a Different Color in Excel! ► • Make Each Column or Bar a Different C...
Chart Aesthetics 101: Customize Legend Text in Excel ► • Chart Aesthetics 101: Customize Legen...
From Default to Custom: Edit Labels & Descriptions in Excel Pivot Tables ► • From Default to Custom: Edit Labels &...
Excel Magic: Preventing Format Changes in PivotTables ► • Excel Magic: Preventing Format Change...
Chart Inside Cells: Create Excel Data Bars Quickly & Easily ► • Chart Inside Cells: Create Excel Data...
Help My Chart Disappeared When I Hid a Column! ► • Help My Chart Disappeared When I Hid ...
Excel Pro Tip: Convert Formulas to Numbers ► • Excel Pro Tip: Convert Formulas to Nu...
#helenbradley #microsoftexcel #microsoftoffice #projectwoman #ExcelShorts #Excelforstudents #excelforbeginners #excelformulaforjobinterview