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 01, 2017.


For more resources for Microsoft Excel