+ Reply to Thread
Results 1 to 5 of 5

# of days a cell has been blank from last date until now

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    81

    # of days a cell has been blank from last date until now

    Hi All,

    Looking for formula or code that cell K4 will look at cell I4 and if their is a date in I4 do nothing, if I4 is blank look in cell E4 (which should have a date in it), then calculate the number of networkdays between cell E4 and the current date (today) the data is entered.

    Their will be many rows with data and each row has multiple places where their could be blank cells. Cells in yellow are where I was planning to put the formula.

    Not sure if code would be a better way to go about this.

    See attached file.

    A blank cell that should have a date in it means someone is working on a task but has not finished, when finished they will Initial and date it and move it on.
    Trying to figure out how many days it has been sitting being worked on from a blank cell that should have a date, to the previous date in that same row.

    Hope this is not too confusing.

    Thanks for any help, Bikeman
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: # of days a cell has been blank from last date until now

    maybe:
    Please Login or Register  to view this content.
    ?
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: # of days a cell has been blank from last date until now

    Thanks very much for the formula, its works for the most part but I did not think about the blank cells down stream.
    If I have one blank cell in the row the formula work fine (see rows 6, 7 & 8) but if their are additional blank cells in the same row to the right, the formula enters a large number (see cells in red).
    Is there a way to keep the additional blank cells to the right that are in the same row "blank". For example row 8 cell O8 resulted in # 32 which is correct but cells S8, W8, AA8, AE8 AI8, AM8, AQ8 and AU8 would remain blank without the large number.

    Hope this is not a pain.

    Thanks for the help, Bikeman
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: # of days a cell has been blank from last date until now

    Try:
    J4:
    Please Login or Register  to view this content.
    K4:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-27-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: # of days a cell has been blank from last date until now

    Thanks, protonLeach! This works great.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting: If Date in cell A1 is greater than 7 days old, flag B1 If blank
    By shepherdc2814 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2013, 11:09 AM
  2. Changing Cell Colour set days before a date and set days after a date.
    By imranrasool in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 04-26-2013, 03:40 AM
  3. Replies: 8
    Last Post: 02-08-2013, 04:29 AM
  4. Replies: 2
    Last Post: 02-07-2013, 04:50 PM
  5. [SOLVED] Complaints Sheet - Highlighting row if blank cell is blank for two days
    By northern88 in forum Excel General
    Replies: 4
    Last Post: 11-01-2012, 07:41 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