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
|