Good morning! I am trying to create a formula for picking a date. I have fiscal month end dates, and I want to create a formula that shows what fiscal today would fall in. The purpose of the formula is to make it easier when the fiscal month end changes because there are several people who use these spreadsheets. I have tried a formula, but it did not work. I have tried two different formulas, but it seems like Excel does not understand putting a date between two the way that I created the formula. I have one cell with =today(), and the I have a list of all of the fiscal dates. I tried to use to =if formulas: one was =IF(I2<I15&I2>I14,I15,(IF(I2<I14&I2>I13,I14,(IF(I2<I13&I2>I12,I13,(IF(I2<I12&I2>I11,I12,(IF(I2<I11&I2>I10,I11,(IF(I2<I10&I2>I9,I10,(IF(I2<I9&I2>I8,I9,(IF(I2<I8&I2>I7,I8,(IF(I2<I7&I2>I6,I7,(IF(I2<I6&I2>I5,I6,(IF(I2<I5&I2>I4,I5,I4))))))))))))))))))))) and the other was =IF(I15>I2>I14,I15,(IF(I14>I2>I13,I14,(IF(I13>I2>I12,I13,(IF(I12>I2>I11,I12,(IF(I11>I2>I10,I11,(IF(I10>I2>I9,I10,(IF(I9>I2>I8,I9,(IF(I8>I2>I7,I8,(IF(I7>I2>I6,I7,(IF(I6>I2>I5,I6,(IF(I5>I2>I4,I5,I4))))))))))))))))))))). I2 is the cell that has today, and the fiscal dates are listed down from earliest to latest. I am just stumped as to a formula to use to pick the correct fiscal. Maybe I am thinking about this all wrong. Any help is appreciated, this will help so that there is less confusion in the offce. Thank you for any help that you can be!! Have a great day!
Bookmarks