Calculate days between 2 dates NON Military format

[ChrisOK]

Looking for a function that will use regular dates and calculate the days between the 2 dates in the gray columns (B) and (E) and place the result in the yellow column (H).

The function needs to hide the error in the yellow column (E)-- when a temporary code of W/A in (B) is present.....

Book3
	A	B	C	D	E	F	G	H
1	DELQTY	CFOB	DEST	WORKORDER/SUB	ESD	CUST	CODE	DAYSofDELINQUENCY
2	1	04/30/03	FB2039	9T61R-AA01	06/30/03	S-MFGS	3
3	1	03/31/03	FB2039	9T94N-AA01	06/30/03	S-MFGS	3
4	50	03/31/03	FB2039	9T27Y-AA01	05/31/03	O-BUYS	13
5	50	03/31/03	FB2039	9T27Y-AA01	05/31/03	O-BUYS	13
6	1	02/11/03	CTIFMS	9T18U-AA01	03/14/03	MFG-S	1
7	5	08/20/03	097X1	9U66K-AA01	W/A	BUYDS	26
8	1	02/11/03	CTIFMS	9T00V-AA01	03/28/03	MFG-S	1
9	1	02/11/03	CTIFMS	9T01V-AA01	W/A	MFG-S	11
10	2	09/15/03	097X1	9U66K-AA04	W/A	BUYDS	11
Sheet1

 

[Aladin Akyurek]

=IF(N(E2),E2-B2,"")

 

[ChrisOK]

Simple and beautiful.

It works - -
OF COURSE!

Thanks again!
:wink: