Excel Magic Trick 534: Conditional Formatting for Weekends and Holidays
Loading...
Loading...
4:39
Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columnsby ExcelIsFun8,228 views- 5:57
Excel Magic Trick 535: Count Weekdays Including Half Days NETWORKDAYS & NETWORKDAYS.INTLby ExcelIsFun3,242 views
- 3:09
Excel Magic Trick #6: Conditional Formatting for a Rowby ExcelIsFun59,202 views
- 2:28
Excel Magic Trick 491: Count Matches in Individual Cellsby ExcelIsFun1,470 views
- 1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun20,371 views
- 7:01
Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)by iProRyan36,383 views
- 8:21
Excel with Conditional Formatingby jeanette4424,860 views
- 6:19
Dashboards in Excelby contactatbiznet137,193 views
- 1:35
Excel lookup with multiple conditions! (extended vlookup)by Psychotec15,461 views
- 1:09:30
Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)by ExcelIsFun7,771 views
- 0:37
World's Greatest News Anchorby kapishViral21,545,134 views
- 2:57
Best Friends Forever episode 2by SoSimlish632,949 views
- 3:34
How to Make A Stick Figure Walkby Dig2GoldZ71,934 views
- 1:03
Turn Excel into Database Management Softwareby Vizubi25,522 views
- 6:43
How to Use an Excel Data Table for "What-if" Analysisby DannyRocksExcels23,713 views
- 4:20
How to Apply Custom Conditional Formating Rules in Excel 2007by knowledgewave4,617 views
- 4:00
Excel: Change the color of a cell based on a certain conditionby everydayexcelstuff6,192 views
- 8:57
Small Business Expenses, Accounting and Bookkeepingby bookkeepingsoftware30,903 views
- 8:52
Construction Schedule using Excel Templateby Queegebo07187,563 views
Cool!
ExcelIsFun 1 year ago
we can change the formula and put it like bellow to make the holiday column expandable =NOT(NETWORKDAYS(A19,A19,E$19:E19))
caribeiro77 1 year ago
Yes, totally streamlined!! I will actually have to make another video to show pererachaminda cool formula!
ExcelIsFun 2 years ago
Just tried =NOT(NETWORKDAYS formula, works great. Streamlined. I always forget about the NOT. Pretty useful sometimes.
krn14242 2 years ago
That is so much cleverer than the formula I used!
As I always say, I am not a smart guy with Excel, just a guy having fun with Excel!
I will make a video about your more efficient formula soon!
ExcelIsFun 2 years ago
you may have already covered this somewhere else. I think we could do the same thing using the "NETWORKDAYS" function.
=NOT(NETWORKDAYS(A19,A19,$E$19:$E$20))
thanks
pererachaminda 2 years ago