Results 1 to 3 of 3

Thread: Excluding Blank cells in Subtarction and the cell value is a Date

  1. #1

    Excluding Blank cells in Subtarction and the cell value is a Date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am using Excel 2007 and i have two columns one for an "expected date" and the other is for "actual date" and i want to subtract to highlight the extra days, anyway, some cells in the "expected date" column are blank and i want to exclude these cells from the formula, what can i do?

  2. #2
    Consider column A is the "expected date" , and column B is the "actual date", column C the subtraction column.
    Put this formula in the 1st cell of column C, then pull down for rest of the cells:
    =IF(A1=""," ",A1-B1)

    (Explanation: If cell A1 is blank, then leave the cell empty, else subtract A1-B1)

  3. #3
    Thanxxxxxxxxxxxxxxxxxxxxxxx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •