Finding number of days between 2 dates

Thanks:  0
Likes:  0

# Thread: Finding number of days between 2 dates

1.
I have a column of dates, and want to have a further column which shows the days between the date in each cell of the column and the current date (i.e the date stored in the system clock). Can anyone suggest any ways of doing this?

Ben

2. =TODAY()-A2

3. I had already tried that I'm afraid, it appears to subtract one date from another, and the output is a date. I was hoping to find a way of outputing a number - so that for instace 17/8/02 would give 3 (taking the date format as dd/mm/yyyy, and todays date as the 14th , 17-14=3.

4. I had already tried that I'm afraid, it appears to subtract one date from another, and the output is a date. I was hoping to find a way of outputing a number - so that for instace 17/8/02 would give 3 (taking the date format as dd/mm/yyyy, and todays date as the 14th , 17-14=3.

5. I had already tried that I'm afraid, it appears to subtract one date from another, and the output is a date. I was hoping to find a way of outputing a number - so that for instace 17/8/02 would give 3 (taking the date format as dd/mm/yyyy, and todays date as the 14th , 17-14=3.

6. I had already tried that I'm afraid, it appears to subtract one date from another, and the output is a date. I was hoping to find a way of outputing a number - so that for instace 17/8/02 would give 3 (taking the date format as dd/mm/yyyy, and todays date as the 14th , 17-14=3.

7. Oops ...

8. This works:

=DATEDIF(A1,NOW(),"d")

9. dbrb2,

You may try to use following formula:

=DATEDIF(Date1,Date2,"D") where Date1, Date2 can refer to cells or constant values.

HTH,
Dennis

10.
On 2002-08-14 07:41, dbrb2 wrote:
This works:

=DATEDIF(A1,NOW(),"d")
So does =TODAY()-A2... You just need to reformat the cell containing this formula as General.

The formula...

=TODAY()-(A2&"")

can also be used to prevent Excel from interpeting the formula's results as a datevalue.

[ This Message was edited by: Mark W. on 2002-08-14 08:00 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•