FUTURE DATE ALERT FORMULA

[VicMLee]

Can I please get some help with the correct formula needed to create a future 6 month and 12 month alert notification in MS Excel relative to my B column? 

[#2 · Accepted solution]

@VicMLee 

=IF(AND(B2>TODAY()+180,B2<TODAY()+360),"6 months",IF(B2>TODAY()+360,"12 months",""))

I would enter this formula in C2 and copy it down.

[#3]

@VicMLee 

Depends on what do you mean under alert. As the basis you could take formula like

=EDATE( B1, 6 )

which returns date 6 months later than one in cell B1.

[#4]

@OliverScheurich Thank you so much for you help. I really appreciate it! 

[#5]

Thank you so much for you help. I really appreciate your time! 

[#6]

@VicMLee , you are welcome