Problem Ageing a Report

[Godwin O.]

Am having a problem of ageing. For exemple, i have the following information
bellow to age

A B C
D
1 31 Jan'06 Computer Set 20,000.00


2 31 Aug'06 Computer Monitor 10,000.00

3 30 Sep'06 Television Set 35,000.00

I want to age the above as at 30 Oct'06 in cell (D), how do i go about this?

 

[Fred Smith]

It depends what your definition of ageing is. If you mean calculating how old
each item is, D1, for example would be:

=date(2006,10,30)-a1

 

[Jim May]

In D1 enter
=DATEDIF(A1,TODAY(),"d")
Should display 271 (the number of days since 1/31/2006)

 

[Godwin O.]

Thanks Fred. I will try it now and get back to U gys