Thread: If formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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?