On worksheet B I have a cell with the formula:
.
On worksheet A I have a table with lots of different calendar information. In column B of this sheet is the work week beginning date, always a Monday. In column C is the work week ending date, always a Friday. I want to take the current date from worksheet B and return the row number in Worksheet A where today's date falls in between the week dates in Column B and C.
Thanks in advance for the help.
TL
Code:
TODAY()
On worksheet A I have a table with lots of different calendar information. In column B of this sheet is the work week beginning date, always a Monday. In column C is the work week ending date, always a Friday. I want to take the current date from worksheet B and return the row number in Worksheet A where today's date falls in between the week dates in Column B and C.
Thanks in advance for the help.
TL