Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Dates Murray Excel Discussion (Misc queries) 3 July 23rd 06 08:59 PM
Sorting Dates dah Excel Discussion (Misc queries) 3 March 23rd 06 03:34 PM
Using IF function with Dates as parameters Shaun Excel Worksheet Functions 4 February 13th 06 09:38 PM
Sorting dates Heather Excel Worksheet Functions 1 June 23rd 05 02:55 AM
Sorting dates Herb Excel Worksheet Functions 3 October 30th 04 01:22 AM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"