richardcdahlgren
Board Regular
- Joined
- Oct 16, 2008
- Messages
- 81
I am trying to use an IF formula to return a 1 or 0 if the date ranges are between given dates. I have project name (B3), start date (b7), end date (b8) (5 and 6 on the vlookup) on a separate Projects List tab. I have tried:
=IF(VLOOKUP($B$2,'Project List'!$B$3:$H$5000,5,FALSE)>=A5<=VLOOKUP($B$2,'Project List'!$B$3:$H$5000,6,FALSE),1,0)
B2 is the project name on the current tab and I have dates listed in column A from 1/1/13 to 12/31/13. A5 is the start date of this project and A7 is the end date. In Column B I am trying to get a 1 for the dates in between and a 0 for dates before and after.
Any help would be greatly appreciated.
Thank you.
=IF(VLOOKUP($B$2,'Project List'!$B$3:$H$5000,5,FALSE)>=A5<=VLOOKUP($B$2,'Project List'!$B$3:$H$5000,6,FALSE),1,0)
B2 is the project name on the current tab and I have dates listed in column A from 1/1/13 to 12/31/13. A5 is the start date of this project and A7 is the end date. In Column B I am trying to get a 1 for the dates in between and a 0 for dates before and after.
Any help would be greatly appreciated.
Thank you.