gr8whthunter76
New Member
- Joined
- Feb 16, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Ok, I am a excel simpleton, but generally I can get things to work. So in Q2 I have this formula =IF(AND($O2>=$C2,$O2<$D2),A2,IF(AND($O2>=$C3,$O2<$D3),A3,IF(AND($O2>=$C4,$O2<$D4),A4,IF(AND($O2>=$C5,$O2<$D5),A5,IF(AND($O2>=$C6,$O2<$D6),A6,IF(AND($O2>=$C7,$O2<$D7),A7,IF(AND($O2>=$C8,$O2<$D8),A8,IF(AND($O2>=$C9,$O2<$D9),A9,IF(AND($O2>=$C10,$O2<$D10),A10,IF(AND($O2>=$C11,$O2<$D11),A11,IF(AND($O2>=$C12,$O2<$D12),A12,IF(AND($O2>=$C13,$O2<$D13),A13,IF(AND($O2>=$C14,$O2<$D14),A14,IF(AND($O2>=$C15,$O2<$D15),A15))))))))))))))
Which then if I put a date in O2 it bumps it against a chart I have and gives me the year I need. That works perfectly. The issue is when I try to automate it more. I put EOD:12/01/2019 in K2 and in M2 I use the formula =RIGHT($K2,LEN($K2)-SEARCH(":",$K2)) to give me the answer of 12/01/2019 in M2. What I want to do is use that answer from M2 be able to put it in O2 and have my formula in Q2 work. I used in O2 =m2 which gives me the date just fine, but doesn't do anything to Q2 which stays as false. NOW if I click on O2 and hit the old fashioned F2 F9 it converts =m2 to a value and all is well. I have tried copy and paste options and that doesn't work either. So confused.
Which then if I put a date in O2 it bumps it against a chart I have and gives me the year I need. That works perfectly. The issue is when I try to automate it more. I put EOD:12/01/2019 in K2 and in M2 I use the formula =RIGHT($K2,LEN($K2)-SEARCH(":",$K2)) to give me the answer of 12/01/2019 in M2. What I want to do is use that answer from M2 be able to put it in O2 and have my formula in Q2 work. I used in O2 =m2 which gives me the date just fine, but doesn't do anything to Q2 which stays as false. NOW if I click on O2 and hit the old fashioned F2 F9 it converts =m2 to a value and all is well. I have tried copy and paste options and that doesn't work either. So confused.