how to enter & query dates in XL 2003

  • Thread starter John G. Barrett
  • Start date
J

John G. Barrett

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
XL 2003 very slow to Copy. XP SP3 2
Changing dates to date format 5
How can I sort Seniority Dates? 3
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Creating a Chart on form from selected data in query. 0
Modern equivalent of Autotext in Word? 0
Dates In Excel 5

Top