Results 1 to 7 of 7

Add number of days to date based on a condition

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    17

    Add number of days to date based on a condition

    Are you able to help, I have a starting date of 07/06/2017 in cell H4, I then want to add the number of days which is in columns C but only if there is a Yes in column D, this works but not if there is a NO. If there is a No, I want it to look at the last date that was calculated e.g. 14/06/2017 and then carry on. I have attached the file.
    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] Counting the number of days overdue based on date and time
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-08-2014, 10:57 AM
  2. [SOLVED] highlight a series of cells based on the number of days in a date range
    By b2lynch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2014, 10:48 PM
  3. Replies: 3
    Last Post: 02-02-2014, 04:26 AM
  4. Replies: 1
    Last Post: 10-24-2013, 09:56 AM
  5. Replies: 8
    Last Post: 05-10-2013, 05:37 AM
  6. Replies: 5
    Last Post: 04-01-2010, 03:07 PM
  7. Replies: 5
    Last Post: 02-11-2010, 05:13 PM

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