Excel Magic Trick

  Рет қаралды 17,719

excelisfun

excelisfun

Күн бұрын

Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
Full Page With All File Links: people.highline...
From a start date and an end date, see how to count all the days except for Sunday using an array formula that uses the functions SUM, IF, ROW, INDIRECT, SUMPRODUCT and TEXT. See a list of 10 different formulas from the mr excel Message Board that will blow your mind.

Пікірлер: 2
@excelisfun
@excelisfun 14 жыл бұрын
I have zero idea how that works - Barry houdini at the Mr Excel Message Board did that. In a few videos ago I mentioned how amazing he is at date formulas!!
Excel Magic Trick #190: Rearrange First Last Name w Formula
3:54
Excel Magic Trick #190: Rearrange First Last Name w Formula
excelisfun
Рет қаралды 21 М.
How to Count a Specific Day of the Week Between Two Dates | How many Fridays?
6:27
How to Count a Specific Day of the Week Between Two Dates | How many Fridays?
Leila Gharani
Рет қаралды 59 М.
Rescue Mission: Breaking into a Car to Save a Dog in 40°C Heat! 🚙🐕☀️ #AnimalRescue #doglover #dog
00:59
Rescue Mission: Breaking into a Car to Save a Dog in 40°C Heat! 🚙🐕☀️ #AnimalRescue #doglover #dog
Wood Mood Arts
Рет қаралды 10 МЛН
My Daughter's Dumplings Are Filled With Coins #funny #cute #comedy
00:18
My Daughter's Dumplings Are Filled With Coins #funny #cute #comedy
Funny daughter's daily life
Рет қаралды 5 МЛН
Папа из-за ТАКОГО снова за хлебом ушёл😁А у тебя есть папа?🤔@KOTFIN
00:19
Папа из-за ТАКОГО снова за хлебом ушёл😁А у тебя есть папа?🤔@KOTFIN
МишАня
Рет қаралды 3,3 МЛН
Incredible: Teacher builds airplane to teach kids behavior! #shorts
00:32
Incredible: Teacher builds airplane to teach kids behavior! #shorts
Fabiosa Stories
Рет қаралды 11 МЛН
Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)
10:01
Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)
excelisfun
Рет қаралды 27 М.
Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria
10:12
Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria
excelisfun
Рет қаралды 167 М.
Excel Magic Trick #121: Count With More Than 1 Criteria Condition
7:35
Excel Magic Trick #121: Count With More Than 1 Criteria Condition
excelisfun
Рет қаралды 31 М.
Excel Magic Trick #215: Dynamic Print Range
7:24
Excel Magic Trick #215: Dynamic Print Range
excelisfun
Рет қаралды 71 М.
Excel: Calculate the Number of Working Days Left This Month
3:38
Excel: Calculate the Number of Working Days Left This Month
Chester Tugwell
Рет қаралды 17 М.
Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets
8:56
Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets
excelisfun
Рет қаралды 30 М.
Функция ВПР в Excel ➤ Как пользоваться функцией ВПР (VLOOKUP) в Excel
18:56
Функция ВПР в Excel ➤ Как пользоваться функцией ВПР (VLOOKUP) в Excel
Андрей Сухов
Рет қаралды 290 М.
Excel Fill Number the right way using the SEQUENCE function
7:07
Excel Fill Number the right way using the SEQUENCE function
Chris Menard
Рет қаралды 108 М.
Excel Magic Trick #173: Time Over or Under (Negative Time)
7:57
Excel Magic Trick #173: Time Over or Under (Negative Time)
excelisfun
Рет қаралды 76 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
5 Excel Secrets You'll Be Embarrassed You Didn't Know
Excel Campus - Jon
Рет қаралды 208 М.
Rescue Mission: Breaking into a Car to Save a Dog in 40°C Heat! 🚙🐕☀️ #AnimalRescue #doglover #dog
00:59
Rescue Mission: Breaking into a Car to Save a Dog in 40°C Heat! 🚙🐕☀️ #AnimalRescue #doglover #dog
Wood Mood Arts
Рет қаралды 10 МЛН