Hi, I am trying to find out what formula to use to add 6 months to a date that is found through an index match formula. It doesn't stop there though as there are some more criteria.
In one tab of the spreadsheet called NEW BID, I have an employee number, name, seniority date, their schedule, and their job. Only the employee number I believe is important here though which spans from A5:A300. There is a separate Tab called Warehouse that lists other information pertinent to wages and PTO time accrued. Please note that this tab does not have EVERY employee, only the ones who were second tier and have different wage increases and accruals. In this tab, it also has the employee number that is also used in NEW BID tab. That number range spans B2:B200 for how many second tier employees there are. The tab also has the date the employee went full-time, which is key to this formula. That range spans H2:H200
So what I am looking to do ultimately is on the NEW BID tab in column H, I want it to look up the employee's Full-Time date on the Warehouse tab. If that full-time date yielded plus 6 months from that date is greater than today's date, I want the cell to display the text "PRB" which means that employee is in a probationary period. I want the cell to be blank if any row in column A is blank OR if the formula yields an error, which in some cases it would. Recall I mentioned that not all employees would be on the Warehouse tab, only second tier employees where the NEW BID tab combines both. So the first tier employees will not have a Full-time date to yield since they are not on the Warehouse tab.
I tried to give all the pertinent info I could think of so if there is any more info needed, please let me know. Thank you.
In one tab of the spreadsheet called NEW BID, I have an employee number, name, seniority date, their schedule, and their job. Only the employee number I believe is important here though which spans from A5:A300. There is a separate Tab called Warehouse that lists other information pertinent to wages and PTO time accrued. Please note that this tab does not have EVERY employee, only the ones who were second tier and have different wage increases and accruals. In this tab, it also has the employee number that is also used in NEW BID tab. That number range spans B2:B200 for how many second tier employees there are. The tab also has the date the employee went full-time, which is key to this formula. That range spans H2:H200
So what I am looking to do ultimately is on the NEW BID tab in column H, I want it to look up the employee's Full-Time date on the Warehouse tab. If that full-time date yielded plus 6 months from that date is greater than today's date, I want the cell to display the text "PRB" which means that employee is in a probationary period. I want the cell to be blank if any row in column A is blank OR if the formula yields an error, which in some cases it would. Recall I mentioned that not all employees would be on the Warehouse tab, only second tier employees where the NEW BID tab combines both. So the first tier employees will not have a Full-time date to yield since they are not on the Warehouse tab.
I tried to give all the pertinent info I could think of so if there is any more info needed, please let me know. Thank you.
Last edited:
