Number of days since a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim M - 27 Jun 2005 12:16 GMT

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

Reply to this Message

Bill Ridgeway - 27 Jun 2005 12:36 GMT

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

> Hi folks,
>
[quoted text clipped - 11 lines]
> Thanks,
> Jim

Reply to this Message

Jim M - 28 Jun 2005 00:30 GMT

> 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

Reply to this Message