BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Good morning, I am looking for some help with a formula. I want to be able to return a date value if the date itself is between a set of dates. In my spreadsheet, I have:
- column A (Lookup Date) has dates that start from 1/1/21 thru 12/31/21 (above dates are just an example)
- column B (Answer) is where I want my returned value to appear
- column C is blank to keep data separate
- column D is the start of the date range for that month
- column E is the end of the date range for that month
- column F is the date value I want returned by looking up the value in column A by using the date ranges in columns E and F
The values in column A go from 1/1/21 thru 12/31/21 and my date ranges also have all 12 months too. I cannot figure out the formula to do this and any help is appreciated.
Thanks
Brett
Lookup Date | Answer | blank column | Start Date Range | End Date Range | Value to Return |
1/1/21 | ? | 1/1/21 | 1/31/21 | 1/1/21 | |
1/2/21 | ? | 2/1/21 | 2/28/21 | 2/1/21 | |
1/3/21 | ? | 3/1/21 | 3/31/21 | 3/1/21 | |
1/4/21 | ? | 4/1/21 | 4/30/21 | 4/1/21 |
- column A (Lookup Date) has dates that start from 1/1/21 thru 12/31/21 (above dates are just an example)
- column B (Answer) is where I want my returned value to appear
- column C is blank to keep data separate
- column D is the start of the date range for that month
- column E is the end of the date range for that month
- column F is the date value I want returned by looking up the value in column A by using the date ranges in columns E and F
The values in column A go from 1/1/21 thru 12/31/21 and my date ranges also have all 12 months too. I cannot figure out the formula to do this and any help is appreciated.
Thanks
Brett