Hi all,
I need assistance with how to set up an Excel formula that allows me to take a hire date and use it to find the pay date that is closest yet exceeds the hire date (i.e. future) and returns a remaining number of pay cycles number from an adjacent column, so that we can calculate offer letter PTO dates for the hire year.
So in B17, I want to return the number of remaining pay periods in the year from column B29 (which goes to 26 pay periods, but it's cut off in the snippet below).
Here is a snippet from my table:
Thank you!
I need assistance with how to set up an Excel formula that allows me to take a hire date and use it to find the pay date that is closest yet exceeds the hire date (i.e. future) and returns a remaining number of pay cycles number from an adjacent column, so that we can calculate offer letter PTO dates for the hire year.
So in B17, I want to return the number of remaining pay periods in the year from column B29 (which goes to 26 pay periods, but it's cut off in the snippet below).
Here is a snippet from my table:
Thank you!