Forum Discussion

VicMLee's avatar
VicMLee
Copper Contributor
Oct 22, 2021

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? 
Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 22, 2021

    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.

SergeiBaklan's avatar
SergeiBaklan
MVP
Oct 22, 2021

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.

  • VicMLee's avatar
    VicMLee
    Copper Contributor
    Oct 27, 2021
    Thank you so much for you help. I really appreciate your time!