Substituting TODAY() for DATE(a,b,c)
 

{=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.

Thanks

Substituting TODAY() for DATE(a,b,c)
 

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.

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.

Substituting TODAY() for DATE(a,b,c)
 

No prob, glad you got going over there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Bad_Shot" wrote in message
...
Max Thanks.
I must not have been doing that, as it works, okay.
Thanks Again