Results 1 to 3 of 3

can you automaticly update the date when it has passed

Threaded View

  1. #1
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    can you automaticly update the date when it has passed

    have the following attached simple(ish) one sheet spreadsheet but just one thing i would like to ask

    the column marked end date has the date in it, is there a formula or function i can add so when the date has passed it adds a whole 12 months to year so 07/03/2018 would become 07/03/2019
    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. Update a cell with a value after a date has passed - Possible???
    By Chris_newton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2013, 04:20 AM
  2. Replies: 1
    Last Post: 09-01-2011, 12:08 PM
  3. Count and Sum Automaticly in specific Date
    By lifeisgood in forum Excel General
    Replies: 5
    Last Post: 01-22-2009, 05:26 AM
  4. Replies: 2
    Last Post: 12-18-2007, 06:09 PM
  5. show the latest date automaticly
    By JustinBourne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2007, 02:12 AM
  6. [SOLVED] HOW CAN I PASTE THE DATE AUTOMATICLY THROUGH DIFFRENT SHEETS
    By nazar in forum Excel General
    Replies: 1
    Last Post: 09-26-2005, 04:05 AM

Tags for this Thread

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