XfortunaX
New Member
- Joined
- Aug 28, 2014
- Messages
- 28
I am stuck on the final formula for a vacation workbook.
I am trying to return the value in column C by referencing the date in column B and placing it next to the correct date on the Sheet listed in column A.
The sheet "Dummy, Taylor".
The 8 entered on 02/10/2015 from above would be on row 16 because it falls between 02/01/2015 and 02/15/15 under vacation hours.
The 24 entered on 05/10/2015 from above would be on row 22 because it falls between 05/01/2015 and 05/15/15 under vacation hours.
I have tried to bend this to fit my needs, but have not been successful:
Formula for matching a date within a date range in excel | Get Digital Help - Microsoft Excel resource
Thank you for any help you can pride,
Tuna
I am trying to return the value in column C by referencing the date in column B and placing it next to the correct date on the Sheet listed in column A.
The sheet "Dummy, Taylor".
The 8 entered on 02/10/2015 from above would be on row 16 because it falls between 02/01/2015 and 02/15/15 under vacation hours.
The 24 entered on 05/10/2015 from above would be on row 22 because it falls between 05/01/2015 and 05/15/15 under vacation hours.
I have tried to bend this to fit my needs, but have not been successful:
Formula for matching a date within a date range in excel | Get Digital Help - Microsoft Excel resource
Thank you for any help you can pride,
Tuna