date notifications from spread sheet

P

Pete_UK

Suppose you have a future date in A1, then you can put this formula in
B1:

=IF(A1-TODAY()<0,"Time's up",IF(A1-TODAY()<8,"One week to go",IF(A1-
TODAY()<31,"Final month","Lots of time yet")))

This should give you some ideas to play with.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone notification 0
Excel --> Word 4
Email notifications without opening application 1
Publisher adding blank page when printing my booklet... 2
Bugs in Office 2019 0
Date Time decimal value help please 1
how do i insert todays date in a spread sheet just prior to print 2
Update several ppt documents from a single excel file 0

Top