Date Function

M

mikelee

try this. in cell a3, use the formula:

=IF(MONTH(A1)<MONTH(TODAY()), "", IF(MONTH(A1)>MONTH(TODAY
())+6,"",AVERAGE(A2:F2)))

you can then copy/paste it to the rest of the columns.
the drawback to that is that it won't wrap around years
(i.e. jan will always be less than dec). if you need it
to wrap, you can try:

=IF(A1<TODAY(), "", IF(A1>TODAY()+182,"",AVERAGE(A2:F2)))

(i used 182 because it's close to half of 365). the
drawback to this one is that, if you have 1/03 in cell
a1, the formula will return a blank on 1/04. if neither
of them work, you can try using various combinations of
the Month() function on the beginning and end of the
criteria to see if it gives you what you want.

hope that helps.

mike
 

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

Excel - Wich Function should I use? 1
Show value from one cell in another cell if today falls between a date range 5
Calendar Logic: Recurring Dates 3
countifs Function not giving desired result with date criteria 2
Avoiding redundant calculations 7
Date lists 3
Current Month with real date 2
If Formula and Dates 4

Top