Finding Excel dates Past & Future

[Venners]

I have a formula to show when a given date was in the past and how long ago it was but I need it to display when a date is in the future as well rather than returning #NUM, if possible just saying "Future" would be fine. The formula I'm using is

=LOOKUP(DATEDIF(H2,TODAY(),"m"),{0,3,6,12},{"Current","3 month","6 month","12 months"})

Does it just need another IF statement or an ELSE for future dates?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IFERROR(LOOKUP(DATEDIF(H2,TODAY(),"m"),{0,3,6,12},{"Current","3 month","6 month","12 months"}),"Future")

 

[Venners]

Thanks Fluff! It worked perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.