Further, you can highlight the range that contains the date. Go to find + replace (CTRL+H), leave the find box empty, replace with ="". Hit replace all. That will change the blank cells such that they are not true blanks. The you can use:

=TODAY()-INDEX(A1:A6,MATCH("",A1:A6,0)-1)

Which does not have to be CSE entered and should be somewhat more efficient than any array formula method used.