I am in need of vb code that takes date imputed into cell and returns the row number associated with date range.
example below Enter Date of 2/14/2019 and code would return Row number as 3 ( for 2/1/2019 thru 2/28/2019 )
<tbody>
</tbody>
note: I have columns in column A (start date) as namedRange "StateDates"
and columns in B(End Date) as namedRange "EndDates"
any help would be greatly appreciated.
Regards,
Hank West
example below Enter Date of 2/14/2019 and code would return Row number as 3 ( for 2/1/2019 thru 2/28/2019 )
Start Date | End Date | Enter Date: | 2/14/2019 | ||
1/1/2019 | 1/31/2019 | Row: | 3 | ||
2/1/2019 | 2/28/2019 | ||||
3/1/2019 | 3/31/2019 | ||||
4/1/2019 | 4/30/2019 | ||||
<tbody>
</tbody>
note: I have columns in column A (start date) as namedRange "StateDates"
and columns in B(End Date) as namedRange "EndDates"
any help would be greatly appreciated.
Regards,
Hank West