Number of days since a date

[Jim M]

Hi folks,

Is there a simple way to calculate in a cell the number of days *since*
a date in a different cell?

For example -

Last used: [12/6/05]
Days ago: [ 15]

It seems so simple, but I can't get my head around Excel's treatment of
dates.

Thanks,
Jim

[Bill Ridgeway]

Put, in cell c2, the formula =a2-b2 where b2 is the later date. C2 will
need to be formatted to number.

Regards.

Bill Ridgeway
Computer Solutions

"Jim M" <jim@deteste_vraiment.le.spam> wrote in message
news:270620051216296712%jim@deteste_vraiment.le.spam...
> Hi folks,
>
> Is there a simple way to calculate in a cell the number of days *since*
> a date in a different cell?
>
> For example -
>
> Last used: [12/6/05]
> Days ago: [ 15]
>
> It seems so simple, but I can't get my head around Excel's treatment of
> dates.
>
> Thanks,
> Jim

[Jim M]

In article <[email protected]>, Bill Ridgeway
<[email protected]> wrote:

> Put, in cell c2, the formula =a2-b2 where b2 is the later date. C2 will
> need to be formatted to number.

So I guess a2 should be todays date?

Ah, you da man Bill! I used =TODAY()-B2 that works great.

Thanks
Jim