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

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find oldest date with a condition 4
How can I have 2 date conditions on the same cell? 5
Number of days 2
Capturing Trend Data over time 1
How do i sort column of date of birth (format dd-month-year)? 6
Calculating the Average for non consecutive cells using custom for 2
IF function to return date content of another cell 7
Another Days, Hours, Minutes, Question 6

Top