Now, let’s use Excel’s RIGHT () function to extract the last two characters from each value. To do so, enter = RIGHT([@Department],2) into H3 and copy to the remaining cells.

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.