CHANGE FORMULA (IF FUNCTION)

[almouchie]

Book2
	A	B	C	D	E	F	G
1	SEQ	CMPUTERSID	DATEIN	DATEOUT	COMPUTERSBILLED	NoofCOMPUTERS	DAYS
2	1	T1	1/2/2005	1/10/2005		5	8
3	2	M2	1/3/2005	1/10/2005		ToConsider	7
4	3	M3	1/5/2005	1/10/2005		4	5
5	4	C4	1/5/2005	1/10/2005	BILLED	Date	1
6	5	T5	1/9/2005	1/10/2005		1/10/2005
7	6	M6	1/10/2005	1/14/2005
8	7	G7	1/11/2005	1/14/2005
9	8	I8	1/12/2005	1/14/2005
10	9	M9	1/13/2005	1/14/2005
11	10	X10	1/13/2005	1/14/2005
Sheet1

HOW CAN I CHANGE THE FORMULAR IN G2 SO AS TO CONSIDER THE COMPUTERS THAT CAME IN THE LATEST NOT EARLIEST (FROM THOSE WITH SAME DATE OUT AS INVOICE)

 

[ken2step]

I don't understand what your looking for here....the formula in Cell G2 has too many arguments for the IF statement for one so I can not tell what your are looking for.
Also your Large function is subtracting a date from an array of dates?????
More info is needed because I can't seem to read between the lines here. I really want to help you.

 

[almouchie]

basically that what i want -
formula whereby it calcualte the days between an invoice date & the dates in for only the computers that left (date out) on same day as day in. & when i filled column F with Billed or anything else so formula can ignore this computer becoz it was billed b4 & doesnt calculate it.
MY PROBLEM is to change formula to consider & calculate the Latest( not earliest) dates in that left same date as invoice.

Is it clearer?