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?
|