For the CF suggestion, you could use instead:
=AND(A1=$B$1,A1<=$B$2,$B$1<"",$B$2<"")
where B1 and B2 would house the input dates
Note that the inputs in B1 & B2 should be real, full* dates, with B2=B1
*dates are entered in full ie inclusive of the year, to avoid any ambiguity
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chi" wrote:
Hi JMay and Max!!
Yes! Thanks for your responses! I created the sheet for the new users and
they don't how to do these steps to get the results.
Is there a way that the users only need to enter the two days and the
results will show like using Access parameters?
Thanks
Chi Huynh