How would I take The info from (2024!B1564) and insert it into (Current Month (2)!N5)?
Keep in mind the Month/date will change every month.
I tried to do =Lookup but keep screwing up the formula, not sure if I should be using =Lookup or not.
Thank you
Keep in mind the Month/date will change every month.
I tried to do =Lookup but keep screwing up the formula, not sure if I should be using =Lookup or not.
Thank you
schedule 4 tracker.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | G | H | ||||
1564 | 1-Mar-24 | 2446 | 1-Mar-24 | |||||||
1565 | 8347 | 1-Mar-24 | ||||||||
1566 | 8362 | 1-Mar-24 | ||||||||
1567 | 8465 | 1-Mar-24 | ||||||||
1568 | 8518 | 1-Mar-24 | ||||||||
1569 | 0 | 1-Mar-24 | ||||||||
1570 | 0 | 1-Mar-24 | ||||||||
1571 | 0 | 1-Mar-24 | ||||||||
1572 | 0 | 1-Mar-24 | ||||||||
1573 | 0 | 1-Mar-24 | ||||||||
1574 | 0 | 1-Mar-24 | ||||||||
1575 | 0 | 1-Mar-24 | ||||||||
1576 | 0 | 1-Mar-24 | ||||||||
1577 | 0 | 1-Mar-24 | ||||||||
1578 | 0 | 1-Mar-24 | ||||||||
1579 | 0 | 1-Mar-24 | ||||||||
1580 | 0 | 1-Mar-24 | ||||||||
1581 | 0 | 1-Mar-24 | ||||||||
1582 | 0 | 1-Mar-24 | ||||||||
1583 | 0 | 1-Mar-24 | ||||||||
1584 | 0 | 1-Mar-24 | ||||||||
1585 | 0 | 1-Mar-24 | ||||||||
1586 | 0 | 1-Mar-24 | ||||||||
1587 | 0 | 1-Mar-24 | ||||||||
1588 | 0 | 1-Mar-24 | ||||||||
1589 | 0 | 1-Mar-24 | ||||||||
2024 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1564:B1589 | B1564 | =(B784) |
H1564 | H1564 | =A1564 |
H1565 | H1565 | =A1564 |
H1566 | H1566 | =A1564 |
H1567 | H1567 | =A1564 |
H1568 | H1568 | =A1564 |
H1569 | H1569 | =A1564 |
H1570 | H1570 | =A1564 |
H1571 | H1571 | =A1564 |
H1572 | H1572 | =A1564 |
H1573 | H1573 | =A1564 |
H1574 | H1574 | =A1564 |
H1575 | H1575 | =A1564 |
H1576 | H1576 | =A1564 |
H1577 | H1577 | =A1564 |
H1578 | H1578 | =A1564 |
H1579 | H1579 | =A1564 |
H1580 | H1580 | =A1564 |
H1581 | H1581 | =A1564 |
H1582 | H1582 | =A1564 |
H1583 | H1583 | =A1564 |
H1584 | H1584 | =A1564 |
H1585 | H1585 | =A1564 |
H1586 | H1586 | =A1564 |
H1587 | H1587 | =A1564 |
H1588 | H1588 | =A1564 |
H1589 | H1589 | =A1564 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B56:B9519 | Expression | =AND($M$2=H56, (ISBLANK(J56))) | text | NO |
B56:B9519 | Expression | =AND($M$2>H56, (ISBLANK(J56))) | text | NO |
B56:B9519 | Expression | =AND($M$2>H56, NOT(ISBLANK(J56))) | text | NO |
C70:G81,C96:G107,C122:G133,C148:G159,C174:G185,C200:G211,C226:G237,C252:G263,C278:G289,C304:G315,C330:G341,C356:G367,C382:G393,C408:G419,C434:G445,C460:G471,C486:G497,C512:G523,C538:G549,C564:G575,C590:G601,C616:G627,C642:G653,C668:G679,C694:G705,C720:G731 | Other Type | Icon set | NO | |
C56:G69,C82:G95,C108:G121,C134:G147,C160:G173,C186:G199,C212:G225,C238:G251,C264:G277,C290:G303,C316:G329,C342:G355,C368:G381,C394:G407,C420:G433,C446:G459,C472:G485,C498:G511,C524:G537,C550:G563,C576:G589,C602:G615,C628:G641,C654:G667,C680:G693,C706:G719 | Other Type | Icon set | NO | |
A4,A30,A56,A108,A160,A212,A264,A316,A368,A420,A472,A524,A576,A628,A680,A732,A784,A836,A888,A940,A992,A1044,A1096,A1148,A1200,A1252,A1304,A1356,A1408,A1460,A1512,A1564,A1616,A1668,A1720,A1772,A1824,A1876,A1928,A1980,A2032,A2084,A2136,A2188,A2240,A2292,A2344 | Expression | =($M$2=A4) | text | NO |
schedule 4 tracker.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
2 | March 2024 | |||||||||||||||
3 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |||||||||
4 | 25 | 26 | 27 | 28 | 29 | 1 | 2 | |||||||||
5 | ||||||||||||||||
6 | ||||||||||||||||
7 | ||||||||||||||||
8 | ||||||||||||||||
9 | ||||||||||||||||
10 | ||||||||||||||||
11 | ||||||||||||||||
12 | ||||||||||||||||
13 | ||||||||||||||||
14 | ||||||||||||||||
15 | ||||||||||||||||
16 | ||||||||||||||||
17 | ||||||||||||||||
18 | ||||||||||||||||
19 | ||||||||||||||||
20 | ||||||||||||||||
21 | ||||||||||||||||
Current Month (2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | C2 | =DATE('Calendar Master'!P8,'Calendar Master'!P10,1) |
C3,E3,G3,I3,K3,M3,O3 | C3 | =C4 |
C4 | C4 | =$C$2-(WEEKDAY($C$2,1)-(start_day-1))-IF((WEEKDAY($C$2,1)-(start_day-1))<=0,7,0)+1 |
E4,G4,I4,K4,M4,O4 | E4 | =C4+1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
P5:P21 | Expression | =O5>0 | text | NO |
P5:P21 | Expression | =AND(NOT(ISBLANK(P5)),AND((TODAY())>O$4,(ISBLANK(O5)))) | text | NO |
O20:O21 | Other Type | Icon set | NO | |
O20:O21 | Expression | =MONTH(O20)<>MONTH($C$2) | text | NO |
O20:O21 | Expression | =OR(WEEKDAY(O20,1)=1,WEEKDAY(O20,1)=7) | text | NO |
O5:O19 | Other Type | Icon set | NO | |
O5:O19 | Expression | =MONTH(O5)<>MONTH($C$2) | text | NO |
O5:O19 | Expression | =OR(WEEKDAY(O5,1)=1,WEEKDAY(O5,1)=7) | text | NO |
N5:N21 | Expression | =M5>0 | text | NO |
N5:N21 | Expression | =AND(NOT(ISBLANK(N5)),AND((TODAY())>M$4,(ISBLANK(M5)))) | text | NO |
M20:M21 | Other Type | Icon set | NO | |
M20:M21 | Expression | =MONTH(M20)<>MONTH($C$2) | text | NO |
M20:M21 | Expression | =OR(WEEKDAY(M20,1)=1,WEEKDAY(M20,1)=7) | text | NO |
M5:M19 | Other Type | Icon set | NO | |
M5:M19 | Expression | =MONTH(M5)<>MONTH($C$2) | text | NO |
M5:M19 | Expression | =OR(WEEKDAY(M5,1)=1,WEEKDAY(M5,1)=7) | text | NO |
L5:L21 | Expression | =K5>0 | text | NO |
L5:L21 | Expression | =AND(NOT(ISBLANK(L5)),AND((TODAY())>K$4,(ISBLANK(K5)))) | text | NO |
K20:K21 | Other Type | Icon set | NO | |
K20:K21 | Expression | =MONTH(K20)<>MONTH($C$2) | text | NO |
K20:K21 | Expression | =OR(WEEKDAY(K20,1)=1,WEEKDAY(K20,1)=7) | text | NO |
K5:K19 | Other Type | Icon set | NO | |
K5:K19 | Expression | =MONTH(K5)<>MONTH($C$2) | text | NO |
K5:K19 | Expression | =OR(WEEKDAY(K5,1)=1,WEEKDAY(K5,1)=7) | text | NO |
J5:J21 | Expression | =I5>0 | text | NO |
J5:J21 | Expression | =AND(NOT(ISBLANK(J5)),AND((TODAY())>I$4,(ISBLANK(I5)))) | text | NO |
I20:I21 | Other Type | Icon set | NO | |
I20:I21 | Expression | =MONTH(I20)<>MONTH($C$2) | text | NO |
I20:I21 | Expression | =OR(WEEKDAY(I20,1)=1,WEEKDAY(I20,1)=7) | text | NO |
I5:I19 | Other Type | Icon set | NO | |
I5:I19 | Expression | =MONTH(I5)<>MONTH($C$2) | text | NO |
I5:I19 | Expression | =OR(WEEKDAY(I5,1)=1,WEEKDAY(I5,1)=7) | text | NO |
H5:H21 | Expression | =G5>0 | text | NO |
H5:H21 | Expression | =AND(NOT(ISBLANK(H5)),AND((TODAY())>G$4,(ISBLANK(G5)))) | text | NO |
G20:G21 | Other Type | Icon set | NO | |
G20:G21 | Expression | =MONTH(G20)<>MONTH($C$2) | text | NO |
G20:G21 | Expression | =OR(WEEKDAY(G20,1)=1,WEEKDAY(G20,1)=7) | text | NO |
G5:G19 | Other Type | Icon set | NO | |
G5:G19 | Expression | =MONTH(G5)<>MONTH($C$2) | text | NO |
G5:G19 | Expression | =OR(WEEKDAY(G5,1)=1,WEEKDAY(G5,1)=7) | text | NO |
F5:F21 | Expression | =E5>0 | text | NO |
F5:F21 | Expression | =AND(NOT(ISBLANK(F5)),AND((TODAY())>E$4,(ISBLANK(E5)))) | text | NO |
E20:E21 | Other Type | Icon set | NO | |
E20:E21 | Expression | =MONTH(E20)<>MONTH($C$2) | text | NO |
E20:E21 | Expression | =OR(WEEKDAY(E20,1)=1,WEEKDAY(E20,1)=7) | text | NO |
E5:E19 | Other Type | Icon set | NO | |
E5:E19 | Expression | =MONTH(E5)<>MONTH($C$2) | text | NO |
E5:E19 | Expression | =OR(WEEKDAY(E5,1)=1,WEEKDAY(E5,1)=7) | text | NO |
D5:D21 | Expression | =C5>0 | text | NO |
D5:D21 | Expression | =AND(NOT(ISBLANK(D5)),AND((TODAY())>C$4,(ISBLANK(C5)))) | text | NO |
C20:C21 | Other Type | Icon set | NO | |
C20:C21 | Expression | =MONTH(C20)<>MONTH($C$2) | text | NO |
C20:C21 | Expression | =OR(WEEKDAY(C20,1)=1,WEEKDAY(C20,1)=7) | text | NO |
C5:C19 | Other Type | Icon set | NO | |
C5:C19 | Expression | =MONTH(C5)<>MONTH($C$2) | text | NO |
C5:C19 | Expression | =OR(WEEKDAY(C5,1)=1,WEEKDAY(C5,1)=7) | text | NO |
C4,E4,G4,I4,O4,C22,E22,G22,I22,K22,O22,C40,E40,G40,I40,K40,O40,C58,E58,G58,I58,K58,O58,C76,E76,G76,I76,K76,M76,O76,K4,C94,M4,M22,M40,M58 | Expression | =MONTH(C4)<>MONTH($C$2) | text | NO |
C4,E4,G4,I4,O4,C22,E22,G22,I22,K22,O22,C40,E40,G40,I40,K40,O40,C58,E58,G58,I58,K58,O58,C76,E76,G76,I76,K76,M76,O76,K4,C94,M4,M22,M40,M58 | Expression | =OR(WEEKDAY(C4,1)=1,WEEKDAY(C4,1)=7) | text | NO |