ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sorting by dates -- parameters? (https://www.excelbanter.com/excel-discussion-misc-queries/136630-sorting-dates-parameters.html)

Chi

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

JMay

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



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com