I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?
I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?
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
"JHL" <[email protected]> wrote in message
news:[email protected]...
> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes",
> "no") and the
> result is not right. Any thoughts?
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
"JHL" wrote:
> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
> result is not right. Any thoughts?
One way:
=IF(AND(cell>=DATE(2005,1,1),cell<DATE(2005,2,1)),"yes","no")
In article <[email protected]>,
JHL <[email protected]> wrote:
> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
> result is not right. Any thoughts?
=AND((A1>=--"2005-01-01")),(A1<--"2005-02-01)"))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"JHL" <[email protected]> wrote in message
news:[email protected]...
> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and
the
> result is not right. Any thoughts?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks