Posted to microsoft.public.excel.newusers
|
|
Substituting TODAY() for DATE(a,b,c)
Max Thanks.
I must not have been doing that, as it works, okay.
Thanks Again
"Max" wrote:
This seems ok ?
Arrray-entered, ie press CTRL+SHIFT+ENTER to confirm the formula:
=MEDIAN(IF(B25:B1023<=TODAY()-180,IF(B25:B1023=TODAY()-365,D25:D1023)))
(did you forget to array-enter earlier when you tried it?)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Bad_Shot" wrote:
{=MEDIAN(IF(B25:B1023<=(DATE(B2,B3,B4)-180),IF(B25:B1023=(DATE(B2,B3,B4)-365),D25:D1023)))}
This works for my data. But requires me to put the date in B2,B3,B4.
I'd like to change the DATE(B2,B3,B4), which I have to update each day, with
TODAY()
I've check the old posts and tried some samples found, but none worked.
The date in B25:B1023 is in the 03/14/2008 00:00 format.
|