# Solved: Excel Dates

Discussion in 'Business Applications' started by Dreambringer, Nov 1, 2005.

Not open for further replies.

Joined:
Jan 19, 2005
Messages:
1,351
Quick question.

Lets say I have a date.

11/01

Is there a formula that would return and IF statement?

For example

I am looking to all the dates between 12/15 and 01/15

I have tried to create a formula using the IF statement, but cant only get the first half.

=IF(A1<=12/15,"TRUE","FALSE")

But how do I get the second half for it to check if if the date is less then 01/15? every time I try I get an error.

2. ### exegete

Joined:
Oct 26, 2005
Messages:
354
Howdy. If I understand correctly. Be sure to check year, since the year will be in the cell whether it displays or not.

=IF(AND(A1<=12/15,A1>01/15),"TRUE","FALSE")

3. ### maxflia10

Joined:
Feb 24, 2003
Messages:
331
Try coercing the date and use a nest IF/AND,

=IF(AND(A1>"12/15/2004"+0,A1<"1/15/2005"+0),If True,If False)

Change the dates etc to suit your needs.

Joined:
Jan 19, 2005
Messages:
1,351
got it! thank alot guys

As Seen On