| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
