Most valuable professional
  • Hot Topics

Excel Counting Blank Cells using TODAY()

Hello all, I have a spreadsheet that I am trying to count the number of days in one column from last entry to TODAY(). I have a date column and then a second column that has delivery amounts. This second column is ONLY used when a delivery is made. I would like to count the number of days from last delivery to TODAY(). I can get the CountBlank to work, but not as a floating count. Also, is there a way to make it so that the formula covers the entire column, but only returns from the last delivery thru current date? Thank you for your help, Joe

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 1, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel