If formula
 

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 formula
 

IF(COUNTIF(A1:D1,""&M1),"Yes","No")

where M1 holds the check date

--
__________________________________
HTH

Bob

"jwbuyer" wrote in message
...
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 formula
 

=IF(AND(A1DATE(2009,1,2,),B1DATE(2009,1,2),C1DA TE(2009,1,2),D1DATE(2009,1,2)),"At
least one is greater","none is greater")
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jwbuyer" wrote in message
...
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 formula
 

jw,

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


HTH,
Bernie
MS Excel MVP


"jwbuyer" wrote in message
...
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 formula
 

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


"jwbuyer" wrote:

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 formula
 

worked like a charm, thanks

"Bob Phillips" wrote:

IF(COUNTIF(A1:D1,""&M1),"Yes","No")

where M1 holds the check date

--
__________________________________
HTH

Bob

"jwbuyer" wrote in message
...
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?