J
JHL
I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?
result is not right. Any thoughts?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Try
=IF(AND(A1>=DATE(2005,1,1),A1<DATE(2005,2,1)),"yes","no")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
=IF(AND(A1>=DATE(2005,1,1),A1<DATE(2005,2,1)),"yes","no")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
B
bpeltzer
Embed the Date function to convert from dates people understand to what Excel
uses: =if(and(cell>=date(2005,1,1),cell<date(2005,2,1)),"yes","no")
--Bruce
uses: =if(and(cell>=date(2005,1,1),cell<date(2005,2,1)),"yes","no")
--Bruce
J
JE McGimpsey
One way:
=IF(AND(cell>=DATE(2005,1,1),cell<DATE(2005,2,1)),"yes","no")
=IF(AND(cell>=DATE(2005,1,1),cell<DATE(2005,2,1)),"yes","no")
B
Bob Phillips
=AND((A1>=--"2005-01-01")),(A1<--"2005-02-01)"))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)