Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to enter & query dates in XL 2003
what's the best way to enter anniversary dates into an XL address file. I
want to keep years and also sort on month Thanx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to enter & query dates in XL 2003
John
Excel will not sort on months. You will need to set up a helper column. Say your dates are in Column B starting in B2. In your helper column, enter this formula in row 2 and drag it down: =Month(B2) Your helper column will now have the month numbers. Sort your data by that helper column. Then you can delete the helper column or keep it for further sorting. HTH Otto "John G. Barrett" wrote in message ... what's the best way to enter anniversary dates into an XL address file. I want to keep years and also sort on month Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter dates with one keystroke | New Users to Excel | |||
How to enter a long address to new web query | Excel Discussion (Misc queries) | |||
How to NOT enter dates? | New Users to Excel | |||
How to enter dates? | New Users to Excel | |||
Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) |