how do I make a function to count days?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

count unique 4
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Sum Function that does not include 0 15
How to write XIRR formula on excel using different Year basis than 365. 5
countif using multiple criteria 6
Excel Formula - Count Dates from another Sheet 8
conditional sum query 1
how do i know date after no. of working days 6

Back
Top