please help I need a formula to give me the days between 10 dates in a colum and today's date which I have at the top of a seperate colum. There is only one cell that contains today's date however there are multiple dates it needs to be matched up against . I seemed to get the answer I'm after but in the colum with variable dates there are cells that don't have dates and the cell beside those empty cells come up with the #value! Error. If I could insert photos or would be much easier to explain sorry in advance
in the colum under today's date I have gotten the value of days in after but in the blank cells it says #value error .