Date verification

[Sam1047]

I need help on the following worksheet.
I need column p3 thur z 3 to check the due date in g3. The date can be 15 days earlier or 15 days later that the due date. (to be considered.. some months have 31 days). I have conditional formats on the cells now, but when the payments is EXACTLY 15 days it highlights as wrong, when infact it is not. Any help would be appreciated.

REHABCHECKLIST.xls
	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
1			List	Client		Due	PLUS	MINUS	RAB	Coll	Coll	Rehab	dueto	#Pay	ActualPaymentDate
2	Acct#	DebtorName	Date	ID	SS#	Date	15days	15days	Balance	ID	Unit	LtrFile	pay	Memts	1st	2nd	3rd	4th	5th	6th	7th	8th	9th	10th	11th	12th
3			Aug-02			08/15/02			$1.00	AP	12	JULY	Aug-03	4	08/19/02	09/30/02	10/21/02	11/15/02
4			Jan-02			08/15/02			$2.00	JE	4	JULY	Aug-03	3	08/19/02	09/30/02	10/30/02
5			May-01			04/22/02			$3.00	MW	12		Apr-03	7	04/22/02	05/22/02	07/03/02	07/31/02	09/06/02	10/04/02	11/15/02
6			Jan-02			05/15/02			$4.00	CBB	1	APR	Mar-03	6	05/09/02	06/14/02	07/29/02	08/30/02	09/13/02	10/15/02
Current REHABS

 

[Joe4]

If the dates are setup in date format, it shouldn't matter that some months have 31 days, since you can subtract two dates and get the number of days.

Without seeing your formula, I am not sure how you wrote it, but if you want 15 days to be OK, just have it check for 16 days or greater instead of 15.

Hope this helps.

 

[Sam1047]

Thanks... the conditional formating is condition 1 cell value is greater than =$h4
condition 2 cell value is equal to 0
condition 2 cell value is less than =$I4
that is the condition for cell the first date
second date the conditional format is the same except condition 1 is +30 and condition 3 is also +30 ..
the third date is +60 and so on and so forth. This works for the most part, unless the date is EXACTLY 15 days .. I can do 16 days. The requiremnt for the date MUST BE 15 days.. if they person does not make the payment in 15 days. They are out of the program.