Hi Tony

Assuming your dates start in D1 and go across the page, A2 contains the
day of month, B2 contains Description and C2 contains Amount, then enter
in D2
=IF(AND($A2=DAY(D$1),$A2<=DAY(E$1)),$C2,"")
and copy across and down as required

--
Regards

Roger Govier


"TonyD" wrote in message
...
I want to create a formula that checks a header date to see if it falls
in
the range of six days before or six days after a monthly payment
required
date. I tried using wildcards such ?? or ~ to substitute month or year
in the
following example. 01 & 10 represent the date of month the bill is
required
to be paid.



01/25/07 02/01/07 02/08/07 02/15/07 02/22/07
01 Maintenance 300.00
10 VISA $100.00