Results 1 to 7 of 7

Auto-Generate Value Based on Date

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2018
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    5

    Auto-Generate Value Based on Date

    Hello!

    I would like a formula to generate the value "7" to cells in B column when the date listed in A column has passed.

    For example, my A column contains dates 3/1/18, 4/1/18, 5/1/18 and so on. What formula can I use so that my B column auto-generates a value of 7 when the date in its corresponding A column has passed?
    Last edited by eeframe27; 07-19-2018 at 03:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date auto generate problem
    By AVG123 in forum Excel General
    Replies: 2
    Last Post: 01-17-2017, 01:14 AM
  2. [SOLVED] Auto Generate an ID# based on date
    By jme1013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2016, 07:21 PM
  3. [SOLVED] Auto-Generate 'record' number based on date
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2015, 12:23 AM
  4. Auto generate the date today but 3 years from now
    By aledrhys666 in forum Excel General
    Replies: 3
    Last Post: 07-10-2013, 09:31 AM
  5. Auto-Generate Due Date based on Ship Date, and other things
    By cjmorin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-18-2011, 02:51 PM
  6. auto generate based on percentage?
    By tondrey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 03:38 PM
  7. formula to generate month-to-date based on auto date
    By infinitysales in forum Excel General
    Replies: 1
    Last Post: 06-27-2008, 01:09 AM

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