In A1 enter the beginning date you want to count from
In B1 enter =TODAY()
In C1 enter =B1-A1

Make sure the number format is set to general in cell C1

"poolgirl" wrote:

I need to keep track of how many dates the local swimming pool is open. When
I type in a date (for instance, May 15) in cell A1, I want cell B1 to tell me
that is day 1. When I enter the next date (May 16) in A1, I want B1 to tell
me it is day 2.
How can I keep track of how many days the pool is open?