Formula? Ongoing count of days from a date

[rentonhighlands]

Hello:
I add a date say 3/2/18 in Cell A1. In cell A2 I want that cell to be a ongoing counter of calendar days from date 3/2/18. Is there a formula I can use?

 

[cerfani]

=A1+1

drag down

 

[rentonhighlands]

? For each day that passes will excel continue to add 1 day?

 

[cerfani]

Days don't pass in Excel but if you mean that when you drag the formula down it will add 1 to the cell above it and since the cells will have dates it will increment the dates by one day then yes that is what it will do.

 

[craigexcel]

Perhaps in cell [A2]: =TODAY()-A1