how do I make a function to count days?

K

khamsta

I need a formula to count days using the system date, example: my list of
days Oct. 1-30 should read Oct. 2-31 tomorrow
 
T

tjtjjtjt

This might work. Example assumes you are in Column A:
In A1, use the Function: =Today()
In A2, use: =A1+1
Copy the formula in A2 down as far as necessary.

This way of doing it probably wouldn't mix well with Sorting.

tj
 
T

tjtjjtjt

If you want the Start day to be in the past, Subtract days from the =Today()
Function.
Example:
=Today()-31 would return 10/1/04.

tj
 
Top