You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.

Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.