Date formula

Sivvy Posts 1 Registration date Wednesday July 24, 2013 Status Member Last seen July 24, 2013 - Jul 24, 2013 at 03:51 PM
Please help with this
The formula is 2 dates When the date is almost reached for promotion on a member The excel program will popup a flag or message to indicate to update members promotion