Forum Discussion
FUTURE DATE ALERT FORMULA
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?
=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.
=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.
OliverScheurich Thank you so much for you help. I really appreciate it!
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.
- Thank you so much for you help. I really appreciate your time!
VicMLee , you are welcome
