| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Help | Excel Discussion (Misc queries) | |||
| Problem with MS Community Newsgroups? | Excel Discussion (Misc queries) | |||
| use the current row in a list to populate a report | Excel Worksheet Functions | |||
| Copying only report sheets | Excel Discussion (Misc queries) | |||
| Pivot Table Report Parameters to be named and saved like 'View' na | Excel Discussion (Misc queries) | |||
Linear Mode
