Yearly Attendance Record - Formula Help!

[Justinian]

I do payroll for 100 people. Each person has an attendance record with one full year of data (only used to note vacation, sick, leave of absence, tardiness, etc). Up until now, this was all done by hand and I am trying to make my lief easier by creating the sheet in Excel to do some math for me. I need help with two things and hope someone can assist!

1. When I insert a slash or format a cell with a slash, I need a formula or some CF that sees that slash and highlights a cell for that specific date. When an employee receives a slash, they were either late or left early and the manager needs to see a note for that day.

2. When an employee's hire date hits, they re-up their benefit hours (sick, vacation, and holidays). I already have a running total and an amount for theuir re-up but I want to incorporate a formula that knows when that anniversay date is and adds the new package amounts to the existing hours that employee has.

Can anyone help?

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:59px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:31px;" /><col style="width:33px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td><td >AF</td><td >AG</td><td >AH</td><td >AI</td><td >AJ</td><td >AK</td></tr><tr style="height:14px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="color:#008080; font-family:Arial; ">NAME OF EMPLOYEE</td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; ">DEPARTMENT</td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; ">NUMBER</td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; ">YEAR</td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td style="color:#008080; font-family:Arial; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:13px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:33px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">MONTH</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">1</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">2</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">3</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">4</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">5</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">6</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">7</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">8</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">9</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">10</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">11</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">12</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">13</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">14</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">15</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">16</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">17</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">18</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">19</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">20</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">21</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">22</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">23</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">24</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">25</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">26</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">27</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">28</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">29</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">30</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">31</td><td > </td><td style="text-align:center; ">Vacation</td><td style="text-align:center; ">Sick</td><td style="text-align:center; ">Floating</td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="color:#008080; text-align:center; ">Jan</td><td > </td><td style="text-align:center; ">s</td><td > </td><td > </td><td style="text-align:center; ">s</td><td > </td><td > </td><td style="text-align:center; ">v</td><td > </td><td > </td><td style="text-align:center; ">fh</td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="text-align:center; ">s</td><td > </td><td > </td><td > </td><td style="text-align:center; ">fh</td><td > </td><td > </td><td style="text-align:center; ">v</td><td style="text-align:center; ">v</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="text-align:center; ">3</td><td style="text-align:center; ">3</td><td style="text-align:center; ">2</td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">Feb</td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="color:#008080; text-align:center; ">Mar</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccffcc; color:#008080; text-align:center; ">Apr</td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td style="background-color:#ccffcc; color:#008080; "> </td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >AI6</td><td >=IF(COUNTA<span style=' color:008000; '>(C6:AG6)</span>=0,"",COUNTIF<span style=' color:008000; '>(C6:AG6,"v")</span>)</td></tr><tr><td >AJ6</td><td >=IF(COUNTA<span style=' color:008000; '>(C6:AG6)</span>=0,"",COUNTIF<span style=' color:008000; '>(C6:AG6,"s")</span>)</td></tr><tr><td >AK6</td><td >=IF(COUNTA<span style=' color:008000; '>(C6:AG6)</span>=0,"",COUNTIF<span style=' color:008000; '>(C6:AG6,"fh")</span>)</td></tr><tr><td >AI7</td><td >=IF(COUNT<span style=' color:008000; '>(C7:AG7)</span>=0,"",COUNTIF<span style=' color:008000; '>(C7:AG7,"v")</span>)</td></tr><tr><td >AJ7</td><td >=IF(COUNTA<span style=' color:008000; '>(C7:AG7)</span>=0,"",COUNTIF<span style=' color:008000; '>(C7:AG7,"s")</span>)</td></tr><tr><td >AK7</td><td >=IF(COUNTA<span style=' color:008000; '>(C7:AG7)</span>=0,"",COUNTIF<span style=' color:008000; '>(C7:AG7,"fh")</span>)</td></tr><tr><td >AI8</td><td >=IF(COUNT<span style=' color:008000; '>(C8:AG8)</span>=0,"",COUNTIF<span style=' color:008000; '>(C8:AG8,"v")</span>)</td></tr><tr><td >AJ8</td><td >=IF(COUNTA<span style=' color:008000; '>(C8:AG8)</span>=0,"",COUNTIF<span style=' color:008000; '>(C8:AG8,"s")</span>)</td></tr><tr><td >AK8</td><td >=IF(COUNTA<span style=' color:008000; '>(C8:AG8)</span>=0,"",COUNTIF<span style=' color:008000; '>(C8:AG8,"fh")</span>)</td></tr><tr><td >AI9</td><td >=IF(COUNT<span style=' color:008000; '>(C9:AG9)</span>=0,"",COUNTIF<span style=' color:008000; '>(C9:AG9,"v")</span>)</td></tr><tr><td >AJ9</td><td >=IF(COUNTA<span style=' color:008000; '>(C9:AG9)</span>=0,"",COUNTIF<span style=' color:008000; '>(C9:AG9,"s")</span>)</td></tr><tr><td >AK9</td><td >=IF(COUNTA<span style=' color:008000; '>(C9:AG9)</span>=0,"",COUNTIF<span style=' color:008000; '>(C9:AG9,"fh")</span>)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="Excel Jeanie Html

 

[Justinian]

Here is my spread. If any dates contain a slash, I want a cell - any cell - under the table to highlight and reflect the date that contains a slash so I can enter a note about why that person was late or left early.

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
5	MONTH	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
6	Jan
7	Feb
8	Mar
9	Apr
10	May
11	Jun
12	Jul
13	Aug
14	Sep
15	Oct
16	Nov
17	Dec
Sheet1

 

[bschwartz]

I can't think of a great solution to return the Month and Day of every slash that is entered in the table above.

Can anyone else assist with this?

 

[bschwartz]

This seems to be working:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	MONTH	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
2	Jan
3	Feb
4	Mar
5	Apr
6	May
7	Jun
8	Jul							/
9	Aug
10	Sep
11	Oct
12	Nov
13	Dec
14
15		Jul - 7
Sheet1

Cell Formulas
Range	Formula
B15	=IFERROR(DATE(13,AGGREGATE(14,6,MATCH(B1:AF1, CHOOSE({1;2;3;4;5;6;7;8;9;10;11;12},MATCH("/",B2:AF2,0),MATCH("/",B3:AF3,0),MATCH("/",B4:AF4,0), MATCH("/",B5:AF5,0),MATCH("/",B6:AF6,0),MATCH("/",B7:AF7,0),MATCH("/",B8:AF8,0),MATCH("/",B9:AF9,0), MATCH("/",B10:AF10,0),MATCH("/",B11:AF11,0),MATCH("/",B12:AF12,0),MATCH("/",B13:AF13,0)),0),1), AGGREGATE(14,6,MATCH(CHOOSE({1;2;3;4;5;6;7;8;9;10;11;12},MATCH("/",B2:AF2,0),MATCH("/",B3:AF3,0),MATCH("/",B4:AF4,0), MATCH("/",B5:AF5,0),MATCH("/",B6:AF6,0),MATCH("/",B7:AF7,0),MATCH("/",B8:AF8,0), MATCH("/",B9:AF9,0),MATCH("/",B10:AF10,0),MATCH("/",B11:AF11,0),MATCH("/",B12:AF12,0), MATCH("/",B13:AF13,0)),B1:AF1,0),1)),"")

Additionally, for cell B15, use conditional formatting rule =B15<>"", and choose a format.

Let me know if that works for you.

 

[Justinian]

Wow, that is a long formula! In what cells shoudl I insert?

 

[bschwartz]

It should work anywhere. I used B15. The conditional formatting rule 'as is' will only work in B15, but you can easily change the cell reference to enable it to work anywhere.

 

[Justinian]

When I enter the formula, I noticed it's only covering through August. For whatever reason, Excel Jeanie chnaged my rows. My spreadsheet data is actually C6:AG17. How do I modify your formula?

 

[bschwartz]

Try this:

=IFERROR(DATE(13,AGGREGATE(14,6,MATCH(C5:AG5,CHOOSE({1;2;3;4;5;6;7;8;9;10;11;12},
MATCH("/",C6:AG6,0),MATCH("/",C7:AG7,0),MATCH("/",C8:AG8,0),MATCH("/",C9:AG9,0),
MATCH("/",C10:AG10,0),MATCH("/",C11:AG11,0),MATCH("/",C12:AG12,0),MATCH("/",C13:AG13,0),
MATCH("/",C14:AG14,0),MATCH("/",C15:AG15,0),MATCH("/",C16:AG16,0),MATCH("/",C17:AG17,0)),0),1),
AGGREGATE(14,6,MATCH(CHOOSE({1;2;3;4;5;6;7;8;9;10;11;12},MATCH("/",C6:AG6,0),
MATCH("/",C7:AG7,0),MATCH("/",C8:AG8,0),MATCH("/",C9:AG9,0),MATCH("/",C10:AG10,0),
MATCH("/",C11:AG11,0),MATCH("/",C12:AG12,0),MATCH("/",C13:AG13,0),MATCH("/",C14:AG14,0),
MATCH("/",C15:AG15,0),MATCH("/",C16:AG16,0),MATCH("/",C17:AG17,0)),C5:AG5,0),1)),"")

 

[Justinian]

Ok, that works! I just ran into another problem though. When I enter an "S" or "FH" into the cells, I want the vacation balance to remain blank. I only want the formula seen below to run when a "V" is entered. What did I do incorrectly?

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
5	MONTH	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31		Vacation	Sick	Floating
6	Jan					S					S	S	S	S	S	S	S	S	S	S	S	S	S	S	S									-180
7	Feb																																	#####
8	Mar																																	#####
9	Apr																																	#####
10	May																																	#####
11	Jun																																	#####
12	Jul																																	#####
13	Aug																																	#####
14	Sep																																	#####
15	Oct																																	#####
16	Nov																																	#####
17	Dec																																	#####
Sheet1

 

[Justinian]

Excel Workbook
	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
5	21	22	23	24	25	26	27	28	29	30	31		Vacation	Sick	Floating
6	S	S	S	S									-180
7													#####
8													#####
9													#####
10													#####
11													#####
12													#####
13													#####
14													#####
15													#####
16													#####
17													#####
Sheet1

 

[bschwartz]

I'm not sure, since it seems to be working fine on mine. However, can't we simplify this to just:

=COUNTIF(C6:AG6,"v")*8-$AI$21

?