yogi_Pull Employee Review Dates By Specified Year

Google Spreadsheet   Post  #2286

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-14-2017

question by: Ace Avant

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/eRM1ysbVrSs;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false

Query by year?

Hello everyone,

I have been searching through the forums in search for a formula that would query items that are for a specific years with no luck. Maybe you all can give me any advice. What I am trying to achieve is having a master sheet named, Master Sheet and create other sheets labeled, 2016 Reviews, 2017 Reviews, 2018 Reviews, etc.. In the Master Sheet, Columns A-E contain employee information like Employee #, Name, Pay, Group, etc.. And in columns F, H, J, etc.., contain dates of evaluation performed every 6 months. How can I query information from the Master Sheet to the other sheets based on the year when a column may have 2 or 3 different years when I'm only looking for sheet 'Review 201X' each to display dates for that respective year.

Any advice is appreciated,

Thanks