Hi,
The following table is in worksheet 'Calvings-By-Cow'
<tbody>
</tbody>
The following table is the worksheet I need a formula to go in column G
<tbody>
</tbody>
The formula in column G needs to 1st match the value in column M with the value in Column G in 'Calvings-By-Cow' & then it needs to return the date from column M in 'Calvings-By-Cow' if only 1 date is found in that row. If more than 2 dates are found in that row then it needs to return the value that is the 'closest less than date' in the row match in 'Calvings-By-Cow' to column D.
I have inserted the dates in column G that the formula needs to return.
Any helpers with this formula ??
The following table is in worksheet 'Calvings-By-Cow'
G | M | P | Q | T | U | |
1 | 3 | 23-May-14 | ||||
2 | 6 | 29-Sep-14 | 09-Sep-15 | 26-Aug-16 | ||
3 | 18 | 12-Jan-15 | 23-Sep-16 | 21-Sep-17 | ||
4 | 22 | 05-Apr-15 | 09-Nov-15 | 02-Nov-16 |
<tbody>
</tbody>
The following table is the worksheet I need a formula to go in column G
D | G | M | ||
12 | 30-May-14 | 23-May-14 | 3 | |
13 | 30-Dec-15 | 09-Sep-15 | 6 | |
14 | 30-Sep-17 | 21-Sep-17 | 18 | |
15 | 15-Dec-15 | 09-Nov-15 | 22 |
<tbody>
</tbody>
The formula in column G needs to 1st match the value in column M with the value in Column G in 'Calvings-By-Cow' & then it needs to return the date from column M in 'Calvings-By-Cow' if only 1 date is found in that row. If more than 2 dates are found in that row then it needs to return the value that is the 'closest less than date' in the row match in 'Calvings-By-Cow' to column D.
I have inserted the dates in column G that the formula needs to return.
Any helpers with this formula ??
Last edited: