Generating Rest Day Formula

M

Marcusandkylie

New Member
Joined
May 4, 2019
Messages
12
Hello excel users!!

What are the formulas to generate 3+, 2, and 1 rest days in columns D and I? Almost seems like it's done manually.

NBA-Sample-League-Schedule (4).xlsx
ABCDEFGHIJ
12021-2022 NBA REGULAR SEASON LEAGUE SCHEDULE
2
3DATEGAME TIME (EASTERN)GAME TIME (LOCAL)REST DAYSROAD TEAMHOME TEAMREST DAYSARENA
410-197:30 PM6:30 PM3+Brooklyn NetsMilwaukee Bucks3+Fiserv Forum
510-1910:00 PM7:00 PM3+Golden State WarriorsLos Angeles Lakers3+Staples Center
610-207:00 PM7:00 PM3+Indiana PacersCharlotte Hornets3+Spectrum Center
710-207:00 PM7:00 PM3+Chicago BullsDetroit Pistons3+Little Caesars Arena
810-207:30 PM7:30 PM3+Boston CelticsNew York Knicks3+Madison Square Garden
910-207:30 PM7:30 PM3+Washington WizardsToronto Raptors3+Scotiabank Arena
1010-208:00 PM7:00 PM3+Cleveland CavaliersMemphis Grizzlies3+FedExForum
1110-208:00 PM7:00 PM3+Houston RocketsMinnesota Timberwolves3+Target Center
1210-208:00 PM7:00 PM3+Philadelphia 76ersNew Orleans Pelicans3+Smoothie King Center
1310-208:30 PM7:30 PM3+Orlando MagicSan Antonio Spurs3+AT&T Center
1410-209:00 PM7:00 PM3+Oklahoma City ThunderUtah Jazz3+Vivint Arena
1510-2010:00 PM7:00 PM3+Denver NuggetsPhoenix Suns3+Footprint Center
1610-2010:00 PM7:00 PM3+Sacramento KingsPortland Trail Blazers3+Moda Center
1710-217:30 PM7:30 PM3+Dallas MavericksAtlanta Hawks3+State Farm Arena
1810-218:00 PM8:00 PM1Milwaukee BucksMiami Heat3+FTX Arena
1910-2110:00 PM7:00 PM3+Los Angeles ClippersGolden State Warriors1Chase Center
2010-227:00 PM7:00 PM1Charlotte HornetsCleveland Cavaliers1Rocket Mortgage FieldHouse
2110-227:00 PM7:00 PM1New York KnicksOrlando Magic1Amway Center
2210-227:00 PM7:00 PM1Indiana PacersWashington Wizards1Capital One Arena
2310-227:30 PM7:30 PM1Toronto RaptorsBoston Celtics1TD Garden
2410-227:30 PM7:30 PM2Brooklyn NetsPhiladelphia 76ers1Wells Fargo Center
2510-228:00 PM7:00 PM1New Orleans PelicansChicago Bulls1United Center
2610-228:00 PM7:00 PM1Oklahoma City ThunderHouston Rockets1Toyota Center
2710-229:00 PM7:00 PM1San Antonio SpursDenver Nuggets1Ball Arena
2810-2210:00 PM7:00 PM1Phoenix SunsLos Angeles Lakers2Staples Center
2910-2210:00 PM7:00 PM1Utah JazzSacramento Kings1Golden 1 Center
NBA-SCHEDULE
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Question Question
STDEV.P formula
Replies
2
Views
494
robfl22
R
J
  • Question Question
Combo Box Mysteriously moves with Grouped Cells
Replies
4
Views
612
jefferyshall
J
W
  • Solved
How to highlight top 10 duplicates in a column
Replies
7
Views
646
Peter_SSs
Peter_SSs
R
  • Question Question
Help!
Replies
3
Views
2K
63falcondude
63falcondude

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top