Matching Computer's Month with the month specified in column

  • Hello

    I was struggling to think what should be the subject of this post as I am unsure what this function/process is called. Anyway, my apologies if the subject looks confusing.

    Here's what I am trying to achieve:

    I have a spreadsheet with a list of people. They are all paid quarterly (three-monthly), however their quarters are different depending upon the date they join. For some people, payments are made Jan-Apr-Jul-Dec for some it is Feb-May-Aug-Jan and so on. I have a column where the payment months are specified in front of each person. I can also make 4 individual columns saying Q1,Q2,Q3,Q4 and specify the months under each if that makes it any easier for Excel to understand.

    I run monthly reports on 5th of each month to see who needs to be paid that month. I am trying to figure out a way to automate this process. So Excel will only pick the records that have System's (Computer's) Month mentioned in the Q1,Q2,Q3 or Q4 columns.

    Is there a function in excel that can do this or can someone help me with the code for this.

    Thanks in advance !

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!