Results 1 to 6 of 6

Calculate next date in series of dates

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2000
    Posts
    4

    Calculate next date in series of dates

    I have a spreadsheet that lists items in column A with a start date in column B. What I need to do is in in column C list the next review date in increments of 5 days, but I only want the next day to show from the current date, not the inputted start date.

    For example:

    Column A Column B Column C
    Item Start Date Next Review Date
    Item A 12-Sept-09 27-Sep-09

    Can I get a formula to calculate the increments and only show the next calendar date for the review, and then to change to the next date once the previous date has passed.

    Alternatively, I have another sheet in my workbook that calculates the dates, is there some way I can display the next future date in a line of dates?

    How I explained this properly, thanks

    Matt
    Last edited by led_blunt; 09-24-2009 at 02:24 PM. Reason: SOLVED

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