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/136621-re-sorting-dates-parameters.html)

Max

sorting by dates -- parameters?
 
One way to highlight using Conditional Formatting ..

Assuming your dates are running in A1 down

Select col A (A1 active)
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(A1=--"12-Jan-2007",A1<=--"5-May-2007")
Click Format Patterns tab Blue? OK
Click OK at the main dialog

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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