Finding number of days between 2 dates

[dbrb2]

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

 

[Mark W.]

=TODAY()-A2

 

[dbrb2]

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.

 

[dbrb2]

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.

 

[dbrb2]

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.

 

[dbrb2]

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.

 

[dbrb2]

Oops ...

Sorry about that

 

[dbrb2]

This works:

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

 

[XL-Dennis]

dbrb2,

You may try to use following formula:

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

HTH,
Dennis

 

[Mark W.]

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