date comparison and formatting

Question

I am trying to compare dates in one column to today's date. If the date is within 3 days of today I would like to count and total it at the bottom of the column.

erol sinan zorlu · Answer

jimfout1964&nbsp;Hello,&nbsp;Below formula should work.&nbsp;SUMIF(DATERANGE;"&gt;="&amp;TODAY()-3;SUMRANGE)

jimfout1964 · Answer

erol sinan zorlu&nbsp;Would i put this formula in the place where I want the total?

erol sinan zorlu · Answer

jimfout1964&nbsp;yes exactly.

jimfout1964 · Answer

erol sinan zorlu&nbsp;Not working, I think I am missing something. the formula is correct but there is no calculation.

erol sinan zorlu · Answer

jimfout1964&nbsp;please check the attached file.

Forum Discussion

date comparison and formatting

5 Replies

Resources