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 !