Number of days since a date

  • Thread starter Thread starter Jim M
  • Start date Start date
J

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
 
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
 
Bill Ridgeway said:
Put, in cell c2, the formula =a2-b2 where b2 is the later date. C2 will
need to be formatted to number.
Click to expand...

So I guess a2 should be todays date?

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

Thanks
Jim
 
Back
Top