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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
Count Dates in a range based on Column Header Id without using sum-product 1
count unique 4
How to write XIRR formula on excel using different Year basis than 365. 5
Sum Function that does not include 0 15
How to change date format to 7 working days a week in ms project 2010? 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Section and Page numbering 0

Top