Hi,
I'm working on a resource model which has names in column A, dates of employment in (mm/yy) format across row 1. I have the names of employees, and how many days they have worked per month over the last 2 years.
As an example you could see:
<tbody>
</tbody>
I'm trying to figure out a way for a formula to look at each row, and where the number chain finishes, give me the corresponding date in row 1 - ie. employees end date. I'm not sure how to write the syntax which would tell excel "where the number chain finishes".
In a similar fashion, do the same for a start date.
Some of the employees may have started mid way though the year as temporary staff, and others may be full-time employees who have decided to leave the organisation.
Appreciate the help!
I'm working on a resource model which has names in column A, dates of employment in (mm/yy) format across row 1. I have the names of employees, and how many days they have worked per month over the last 2 years.
As an example you could see:
End Date | Feb-15 | Mar-15 | Apr-15 | May-15 | |
Employee 1 | Formula | 15 | 20 | ||
Employee 2 | Formula | 17 | 10 | 16 |
<tbody>
</tbody>
I'm trying to figure out a way for a formula to look at each row, and where the number chain finishes, give me the corresponding date in row 1 - ie. employees end date. I'm not sure how to write the syntax which would tell excel "where the number chain finishes".
In a similar fashion, do the same for a start date.
Some of the employees may have started mid way though the year as temporary staff, and others may be full-time employees who have decided to leave the organisation.
Appreciate the help!