+ Reply to Thread
Results 1 to 2 of 2

How do I set up Reminders in an excel spreadsheet?

  1. #1
    Chilli Mel
    Guest

    How do I set up Reminders in an excel spreadsheet?

    I'm trying to set-up a new spreadsheet in Excel for sales and servicing of
    bikes, I want to have something to alert/remind me to contact people for when
    their service is due?

  2. #2
    Forum Contributor
    Join Date
    10-14-2004
    Location
    San Diego, CA
    Posts
    213
    There are plenty of things you can do, try conditional format with this.

    =AND(A1-TODAY()>=0,A1-TODAY()<=30)

    Or

    Paste this into whatever cell, will returns days remaining from today until the specified date code that is in the formula.

    =DATEDIF(NOW(),38779,"d")

    Matt

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1