Subtracting dates for days of rest for a player

mdean32

New Member
Joined
Jan 15, 2019
Messages
22
I have an ongoing database with multiple players. I need a formula to sort days of rest in between games (Column C) without sorting the players. I can get this to work if I sort the player ascending, but this causes extra work with the daily feed. I was wondering if there was a way to do this without sorting? Thanks for your help

PLAYER DATE REST DAYS
PlayerA1-1-19
PlayerB1-3-19
PlayerA1-4-192
PlayerB1-4-190
PlayerA1-8-193
PlayerB1-14-199
PlayerA1-9-190
PlayerB1-16-191

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,219
Try:

Excel 2012
ABC
1PLAYER DATE REST DAYS
2PlayerA1/1/2019
3PlayerB1/3/2019
4PlayerA1/4/20192
5PlayerB1/4/20190
6PlayerA1/8/20193
7PlayerB1/14/20199
8PlayerA1/9/20190
9PlayerB1/16/20191

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
C2=IFERROR(B2-LOOKUP(2,1/($A$1:$A1=A2),$B$1:$B1)-1,"")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,109,054
Messages
5,526,507
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top