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