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

  • Thread starter Thread starter Bad_Shot
  • Start date Start date
B

Bad_Shot

{=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
 
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
 
Back
Top