making excel to notifying you about expire dates on your sheet

[F.M.H]

please can any one help me!
i have in column B some date and i want Excel to notifying me before these
date expired by 20 days in a messege box with the dates that will expired
thank you in advance

 

[Mike H]

You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A1>20

Pick a colour

Mike

 

[F.M.H]

thanks for you Mr. Moke H
but i need it in a message box
thank you in advance
F.M.H

 

[Andymackk]

Thanks Mike,
That helped me!

Andy

You could use conditional formatting
Select your cell and then

Format|Conditional Format
Select formula is and enter this formula
=TODAY()-A1>20

Pick a colour

Mike