COUNTING FORMULA

[hsarrategui]

I want to keep track of how many days late payments are. Is there a way to put the date of invoice in column B and have column D count automatically enter the number of days? To where it changes every day to keep count?

 

[breynolds0431]

Hi there.

The formula =TODAY() will return today's date. So, in cell D2, if you put =TODAY()-B2, you should get the day count you need to see that will update each day you open the workbook.