Problem Ageing a Report
 

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?

Problem Ageing a Report
 

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

--
Regards,
Fred


"Godwin O." <Godwin wrote in message
...
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?

Problem Ageing a Report
 

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



"Godwin O." wrote:

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?

Problem Ageing a Report
 

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

"Fred Smith" wrote:

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

--
Regards,
Fred


"Godwin O." <Godwin wrote in message
...
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?