Forum Discussion
Return value in IFS based on date
Jpalaci1 See attached. I didn't change your approach. Just amended the formula for you. Be aware that you need to use the $ signs in the correct places if you want to be able to drag the formulae across. Note also that you need to test for months from stage 3 down to stage 1. See attached.
Jpalaci1 See attached. I didn't change your approach. Just amended the formula for you. Be aware that you need to use the $ signs in the correct places if you want to be able to drag the formulae across. Note also that you need to test for months from stage 3 down to stage 1. See attached.
Thank you for this. If there was an alternative to this, what would it be in terms of handling the output in a better manner/different approach?
Jpalaci1 You could work with real dates instead of month numbers. That allows you to use some of Excel's built-in date intelligence functions. Added a small example in the attached file. And then there are probably dozens of other thinkable solutions.