how do I make a function to count days?
 

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

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


"khamsta" wrote:

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

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

"tjtjjtjt" wrote:

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


"khamsta" wrote:

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