# How to find if a date falls between 2 dates

1. ## How to find if a date falls between 2 dates

I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?

2. ## Re: How to find if a date falls between 2 dates

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" <JHL@discussions.microsoft.com> wrote in message
news:42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com...
> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes",
> "no") and the
> result is not right. Any thoughts?

3. ## RE: How to find if a date falls between 2 dates

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?

4. ## Re: How to find if a date falls between 2 dates

One way:

=IF(AND(cell>=DATE(2005,1,1),cell<DATE(2005,2,1)),"yes","no")

In article <42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com>,
JHL <JHL@discussions.microsoft.com> wrote:

> I've tried =if(and(cell=> "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
> result is not right. Any thoughts?

5. ## Re: How to find if a date falls between 2 dates

=AND((A1>=--"2005-01-01")),(A1<--"2005-02-01)"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JHL" <JHL@discussions.microsoft.com> wrote in message
news:42D4A997-0B8E-4739-9743-088C5C4880C2@microsoft.com...
> 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)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1