Forum Discussion
Solved
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!
