date range in an if then statement

's Computer Specifications

I have date ranges that certain things happen on. I need a formula that can
read a cell and determine if it's in betweeen August 16 and November 15, for
example, and return a value if it's true. I'm not sure how to get it to
work.

Thanks

's Computer Specifications

August 16 what year, please provide as much info as possible when you ask a
question, I will assume the year is 2007, if not by looking at the formula
you should be able to adjust it. Also between does that include Aug 16, Nov
15, if not replace <= and >= with < and >

=IF(A2="","",IF(AND(A2>=DATE(2007,8,16),A2<=DATE(2007,11,15)),"Between","Not
between"))

--
Regards,

Peo Sjoblom

"Jimmy" <(E-Mail Removed)> wrote in message
news:834613F9-49EB-4CC7-A64F-(E-Mail Removed)...
>I have date ranges that certain things happen on. I need a formula that
>can
> read a cell and determine if it's in betweeen August 16 and November 15,
> for
> example, and return a value if it's true. I'm not sure how to get it to
> work.
>
> Thanks

's Computer Specifications

Assuming your date is in cell A1 this formula will return true or false...

=AND(A1>=DATE(2007,8,16),A1<=DATE(2007,11,15))
--
HTH...

Jim Thomlinson

"Jimmy" wrote:

> I have date ranges that certain things happen on. I need a formula that can
> read a cell and determine if it's in betweeen August 16 and November 15, for
> example, and return a value if it's true. I'm not sure how to get it to
> work.
>
> Thanks

's Computer Specifications

Try something like the following:

=IF(AND(B2>=DATE(2007,8,16),B2<=DATE(2007,11,16)),TRUE,FALSE)

The formula compares the value in cell B2 to see if it falls between the 2
dates specified. The syntax for DATE is DATE(year,month,day) and the AND
function lets you state the date range.

--
Kevin Backmann

"Jimmy" wrote:

> I have date ranges that certain things happen on. I need a formula that can
> read a cell and determine if it's in betweeen August 16 and November 15, for
> example, and return a value if it's true. I'm not sure how to get it to
> work.
>
> Thanks

's Computer Specifications

Thanks for all the help!!

"Peo Sjoblom" wrote:

> August 16 what year, please provide as much info as possible when you ask a
> question, I will assume the year is 2007, if not by looking at the formula
> you should be able to adjust it. Also between does that include Aug 16, Nov
> 15, if not replace <= and >= with < and >
>
> =IF(A2="","",IF(AND(A2>=DATE(2007,8,16),A2<=DATE(2007,11,15)),"Between","Not
> between"))
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
>
> "Jimmy" <(E-Mail Removed)> wrote in message
> news:834613F9-49EB-4CC7-A64F-(E-Mail Removed)...
> >I have date ranges that certain things happen on. I need a formula that
> >can
> > read a cell and determine if it's in betweeen August 16 and November 15,
> > for
> > example, and return a value if it's true. I'm not sure how to get it to
> > work.
> >
> > Thanks
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
return date from range of dates with if statement	Joe	Microsoft Excel Worksheet Functions	3	3rd Mar 2009 11:24 AM
Adding Date Range to Averageif statement	lwilliams	Microsoft Excel Misc	2	3rd Oct 2008 02:59 PM
Sumif function with a date range condition statement	COskibum	Microsoft Excel Misc	4	24th Jul 2008 07:15 PM
How do I get an IF statement to pull a date range??	=?Utf-8?B?QnJvb2tlIE1lZHZlY2t5?=	Microsoft Excel Worksheet Functions	9	19th Apr 2006 08:48 PM
if statement with date range	=?Utf-8?B?VGhlcmVzYQ==?=	Microsoft Excel Worksheet Functions	3	17th Oct 2005 06:03 PM