Results 1 to 4 of 4

auto populate (dates)

Threaded View

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Leeds, England
    MS-Off Ver
    2010
    Posts
    24

    auto populate (dates)

    Please see the attached spreadsheet (auto populate)

    I need the cells within Column C to auto populate depending on the value is of the adjacent cells within columns A and B.

    If A3 is blank and B3 is blank – C3 needs to be blank
    If A3 has a date in it and B3 has a date in it – C3 needs to equal whatever the most recent date is
    If A3 has a date in it and B3 has N/A in it - C3 needs to equal A3
    If A3 has a date in it and B3 is blank – C3 needs to be blank
    If A3 is blank and B3 has a date in it – C3 needs to be blank

    Please help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-Populate Calendar Dates
    By ajlax4 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 12-05-2017, 04:11 PM
  2. Auto-populate calendar dates
    By zturtles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 09:44 PM
  3. Replies: 2
    Last Post: 07-31-2013, 02:00 PM
  4. Excel 2007 : More auto populate dates
    By grsnipe in forum Excel General
    Replies: 2
    Last Post: 05-10-2011, 06:57 AM
  5. Macro- Auto populate Dates in a range
    By abhishek_k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2010, 12:44 PM
  6. Auto Populate Dates
    By Bundok@mac.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2008, 05:28 PM
  7. Auto populate dates
    By waiter11 in forum Excel General
    Replies: 2
    Last Post: 05-28-2006, 04:55 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