ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Programming
(
https://www.excelbanter.com/excel-programming/
)
- -
Hide data based on future date
(
https://www.excelbanter.com/excel-programming/362990-re-hide-data-based-future-date.html
)
Ardus Petus
Hide data based on future date
=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
All times are GMT +1. The time now is
03:02 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
