SOLVED

FUTURE DATE ALERT FORMULA

Copper Contributor

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?

5 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

Re: FUTURE DATE ALERT FORMULA

=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.

Re: FUTURE DATE ALERT FORMULA

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.

Re: FUTURE DATE ALERT FORMULA

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

Re: FUTURE DATE ALERT FORMULA

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

Re: FUTURE DATE ALERT FORMULA

@VicMLee , you are welcome

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

Re: FUTURE DATE ALERT FORMULA

=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.