I'm trying to get my formula to put the days of savings. Right now it will look up the corresponding quarter and then place the savings in that quarter. My issue is i need it to be a bit more accurate as to the actual dates. An example would be lets say I need to show 180 days of savings and the date I need to start the savings is 10 days before the quarter ends. So i need it to show the 10 days of saving in Q1, 91 days of savings in Q2 then the rest of the days 81 days of savings in Q3. My formula I have now would only put the savings in Q1 and Q2. I believe i need to us Days360() to calculate what i need but i don't know how to put it together
Bookmarks