If formula

  • Thread starter Thread starter jwbuyer
  • Start date Start date
J

jwbuyer

I have four different columns with dates in them. I want to use an if
formula to check whether the dates in either of these columns is greater than
a certain date value. How do use one if formula across all four columns?
 
=IF(AND(A1>DATE(2009,1,2,),B1>DATE(2009,1,2),C1>DATE(2009,1,2),D1>DATE(2009,1,2)),"At
least one is greater","none is greater")
best wishes
 
jw,

=IF(MAX(A3:D3)>DATEVALUE("Mar 6, 2009"),"It's greater","It's not")


HTH,
Bernie
MS Excel MVP
 
See if this works for you:

=IF(MAX(A1:D1,$F$1)=$F$1,"Yes","No")

This assumes your columns are A thru D and your comparison date is stored in
cell F1. Adjust the cell references to meet your needs.

HTH
Elkar
 
worked like a charm, thanks

Bob Phillips said:
IF(COUNTIF(A1:D1,">"&M1),"Yes","No")

where M1 holds the check date

--
__________________________________
HTH

Bob
Click to expand...
 
Back
Top