View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default sorting by dates -- parameters?

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