A little help with the EDATE function.

[Carlos5]

Hello,
I got an answer on this board but I would now like to expand it a little, I hope someone can help. Here goes:

I am currently using the edate function to figure out the expire time from a certain date. that function is as so: =IF(ISBLANK(A1),"No Date",LOOKUP(TODAY(),EDATE(A1,{0,18,21,24}),{"","6 months to expiry","3 months to expiry","expired"})), I would like to replace the months {0,18,21,24} with a reference to a cell, i.e. {A2, A3, A4, A5} but it doesn't seem to work. Is this possible? Am I missing something?
Thanks,
Carlos

 

[Carlos5]

Hello,
I got an answer on this board but I would now like to expand it a little, I hope someone can help. Here goes:

I am currently using the edate function to figure out the expire time from a certain date. that function is as so: =IF(ISBLANK(A1),"No Date",LOOKUP(TODAY(),EDATE(A1,{0,18,21,24}),{"","6 months to expiry","3 months to expiry","expired"})), I would like to replace the months {0,18,21,24} with a reference to a cell, i.e. {A2, A3, A4, A5} but it doesn't seem to work. Is this possible? Am I missing something?
Thanks,
Carlos

Hi everyone, I cross posted this on another board. I did not realize this was a "no no" I apologize. Here is the link: Reference a cell from within the edate function?
Someone gave me a formula but I can't get it to work. I hope one of you can help.
Thanks,
Carlos

 

[Carlos5]

Hello all, this was solved by someone on the other board.