Hie Friends. What formula can l use to calculate a total for today, then the same formula must detect the change of date tomorrow and start a new and fresh calculation which will be only for tomorrow. the next day it will repeat the same process by itself, automatically without being manually dragged down. lam looking for running total for Total Deposited, in Column "J". Currently lam using the formula: =sum($D$2:D5) for cell "J5".Thank you.