=IF(A1TODAY(),"",MyFunc(A1))

HTH
--
AP

"nougain" a écrit
dans le message de news:
...

I have a column A having dates and second one B with a formula that
computes something based on the dates in A column. Dates are like all
mondays of 2006 in chronological order. Now all I want is that for the
dates that are greater than TODAY, cell in second column should appear
blank and not what the result of the formula in it.

A........... B
---------- -----------
..
5/22/2006 10 :result of myfunc(5/22/2006)
5/29/2006 9 :result of myfunc(5/29/2006)
6/5/2006 :result of myfunc(6/5/2006)
6/12/2006 :result of myfunc(6/12/2006)
..

How to do that? What I need to do in my VBA function such that it does
not show result if date is in future?


--
nougain
------------------------------------------------------------------------
nougain's Profile:
http://www.excelforum.com/member.php...o&userid=32031
View this thread: http://www.excelforum.com/showthread...hreadid=547410