| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
| how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
| how do I make a calendar with every three days a different color . | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Linear Mode
