View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default 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?