Discussion on:
View:
Show:
Another great tip, Susan! Excel's fill feature is one of my favorites. I use it often when I'm creating budgets or documents that require dates. Thanks for sharing that we can right-click to access the fill options faster. Have a great day.
I right-click everything. 
Sometimes it does nothing, sometimes... Surprise!
Sometimes it does nothing, sometimes... Surprise! 
If you hold down the Ctrl key while dragging the fill handle, the date will not increment.
Good tips, however, I'm stuck on how to sort by month and date when given the date as mm/dd/yyyy. Is there a way to isolate the month, day, and year?
Two options:
use data to text feature in Data ribbon and use "/" as separator. Sort on month and use CONCATENATE function join in mm/dd/yyy
and more simple way is use customs sort and selct Jan, Feb, Mar as sort order.
You can also use DATE, MONTH and YEAR function to separte date or extract any one component from date cell
use data to text feature in Data ribbon and use "/" as separator. Sort on month and use CONCATENATE function join in mm/dd/yyy
and more simple way is use customs sort and selct Jan, Feb, Mar as sort order.
You can also use DATE, MONTH and YEAR function to separte date or extract any one component from date cell
I create a formula using =Month(A4) where A4 is where the full date (08/16/11) is located. This will show the number 8 in that particular formula column. I then copy the formula for the entire column and then sort the particular area that you want sorted by month. You should check out the =Year(A4) and =Weekday(A4) as well, if you are looking for a particular day of the week.
I've found adding these columns comes in hand when creating pivot tables too.
Good Luck Dyuraovich!
I've found adding these columns comes in hand when creating pivot tables too.
Good Luck Dyuraovich!
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
