If formula

[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?

 

[Bob Phillips]

IF(COUNTIF(A11,">"&M1),"Yes","No")

where M1 holds the check date

 

[Bernard Liengme]

=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

 

[Bernie Deitrick]

jw,

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


HTH,
Bernie
MS Excel MVP

 

[Elkar]

See if this works for you:

=IF(MAX(A11,$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

 

[jwbuyer]

worked like a charm, thanks

IF(COUNTIF(A11,">"&M1),"Yes","No")

where M1 holds the check date

--
__________________________________
HTH

Bob