Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Off Topic > Off Topic - Computers


Reply
 
Thread Tools Rate Thread
Old 03-25-2018, 09:21 PM   #1
Tom
Registered User
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 84,845
Rep Power: 109 Tom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to behold
Excel ?

I have a column in Excel that contains the date 03/24/18
...going back years.

I want to be able to filter dates by month so I can look at race for say 3yos in Jan-March only. Any way to get the month name or number out of that field?
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Old 03-25-2018, 09:40 PM   #2
jay68802
Registered User
 
jay68802's Avatar
 
Join Date: May 2008
Location: Nebraska
Posts: 6,607
Rep Power: 21 jay68802 is a glorious beacon of lightjay68802 is a glorious beacon of lightjay68802 is a glorious beacon of lightjay68802 is a glorious beacon of lightjay68802 is a glorious beacon of light
try looking under more formats, or custom formats.
jay68802 is online now   Reply With Quote Reply
Old 03-25-2018, 10:06 PM   #3
headhawg
Registered User
 
headhawg's Avatar
 
Join Date: Aug 2003
Location: Virtual Reality hell
Posts: 2,894
Rep Power: 17 headhawg is on a distinguished road
I am not sure what version of Excel you have but you should be able to filter by month. Click a cell inside your data set. Go to Home I think? Look for the button in the ribbon. Filter or Sort/Filter. Click Filter. You should get arrows in the top row of your data. I think there's an option for date filters.
headhawg is offline   Reply With Quote Reply
Old 03-26-2018, 08:19 AM   #4
mikesal57
Registered User
 
mikesal57's Avatar
 
Join Date: Sep 2003
Location: NEW YORK CITY
Posts: 1,960
Rep Power: 16 mikesal57 is on a distinguished road
Insert a blank column next to your Date column. Assuming your first date is in cell A4, in the blank column, enter the formula: =TEXT(A4,"MMDD") Copy this formula down to the bottom of your data. Sort your data on this column.
mikesal57 is offline   Reply With Quote Reply
Old 03-26-2018, 09:27 PM   #5
Tom
Registered User
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 84,845
Rep Power: 109 Tom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to beholdTom is a splendid one to behold
Perfect - works just as I need it to.!
Thanks!
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
» Current Polls
How many U.S. tracks will be running full (8+ week) meetings in 2028?
0: We'll all be nuked by then - 5.56%
3 Votes
1-5 - 9.26%
5 Votes
6-10 - 18.52%
10 Votes
11-15 - 20.37%
11 Votes
16-20 - 9.26%
5 Votes
21 or more - 37.04%
20 Votes
Total Votes: 54
Non-members may not vote on this poll.
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 01:21 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Copyright 1999 - 2018 -- PaceAdvantage.Com -- All Rights Reserved -- Best Viewed in a modern browser @ 1280x720 Resolution Or Higher
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.