Good afternoon. Seeking assistance on developing a formula that would return values closest to today's date. We have a payroll projection sheet thats setup for 25 employees over a fiscal year that allows us to breakout someone's salary via percentage thru up to 20 accounts.
Image 1-I setup a table on each's employee's tab that captures what we entered for each pay period (Example Image 1 shows 80% on acct 1, 20% on acct 2) and the breakout over the entire year.
On table 2, I would like to build a formula that does two things. 1. Capture the current account percentage from employee 1's tab (image 1) based on closest to today's date. 2. This formula knows to only give values that match the account number values listed on K2:AD2. The accounts listed on table 2 arent going to match what's on employee's 1 tab, therefore that needs it own match function (if thats possible).
On table 2, only the first row 4 is needed. Aware that each row needs to be setup towards each employee's tab.
Any questions let me know.
Image 1-I setup a table on each's employee's tab that captures what we entered for each pay period (Example Image 1 shows 80% on acct 1, 20% on acct 2) and the breakout over the entire year.
On table 2, I would like to build a formula that does two things. 1. Capture the current account percentage from employee 1's tab (image 1) based on closest to today's date. 2. This formula knows to only give values that match the account number values listed on K2:AD2. The accounts listed on table 2 arent going to match what's on employee's 1 tab, therefore that needs it own match function (if thats possible).
On table 2, only the first row 4 is needed. Aware that each row needs to be setup towards each employee's tab.
Any questions let me know.
