BD column is a date. I need to add a statement ....today

January 18, 2012 at 15:20:29
Specs: Windows 7
=IF(ISNUMBER(MATCH(D13,Status!B:B,0)),INDEX(Status!BD:BD,MATCH(D13,Status!B:B,0)),0)

BD column is a date. I have two colums with the Column BD reference.
1.) If the date is in the future it will populate a blank and if date has past it will produce date in cell.
2.) If the date is in the future it will populate date and if in the past it will produce blank.

I have tried adding >today(),"" and I guess I've stared at this too long and can not fix it. Or I'm adding it in the wrong place, missing a comma or something.

Appreciate your help. :-)


See More: BD column is a date. I need to add a statement ....today

Report •


#1
January 18, 2012 at 15:43:44
I'm having a bit of trouble figuring out what you are trying to do by just seeing the formula.

Would it be possible to post a few pieces of example data and the expected output based on that data?

Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 19, 2012 at 08:04:38
D Statis!B:B Statis!BD
Name Name DOB
Vern Vern 01/18/70
Jane Jane 02/30/2012
Tarzan Tarzan Check Mark Symbol
Milly Milly X Mark Symbol
Trouble Trouble ----

Hope this helps...Thank you...Thank you.


Report •

#3
January 19, 2012 at 13:23:22
Did you read my comment about clicking on the blue line and following the instructions about how to post data in this forum?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question