Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chi Chi is offline
external usenet poster
 
Posts: 69
Default sorting by dates -- parameters?

Hi,

I have a column stored a list of birthday dates. I would like to know who
have birthdays between two dates.


Ex: Between 01/12/2007 to 05/22/2007. I wanted to see all dates that are
between 01/12/07 to 05/22/07.

Thanks
chi

Thanks
Chi Huynh
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default sorting by dates -- parameters?

You could apply an auto-filter to your table and
then select the BDAte Column - CUSTOM (from Drop-down)
and there enter in to the Greater than 1/12/2007
and Less than 5/22/2007

I think that will work..


"Chi" wrote:

Hi,

I have a column stored a list of birthday dates. I would like to know who
have birthdays between two dates.


Ex: Between 01/12/2007 to 05/22/2007. I wanted to see all dates that are
between 01/12/07 to 05/22/07.

Thanks
chi

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 by dates -- parameters? Max Excel Discussion (Misc queries) 0 March 28th 07 02:02 AM
sorting by dates -- parameters? Chi Excel Discussion (Misc queries) 0 March 28th 07 01:56 AM
sorting by dates -- parameters? Max Excel Discussion (Misc queries) 0 March 28th 07 01:51 AM
Using IF function with Dates as parameters Shaun Excel Worksheet Functions 4 February 13th 06 09:38 PM
Sorting dates Herb Excel Worksheet Functions 3 October 30th 04 01:22 AM


All times are GMT +1. The time now is 08:29 PM.

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"