Solved EXCEL If Statement Using Dates

June 25, 2014 at 12:57:25
Specs: Windows 7
I want to have two dates within the if statement. This is what I made, but i need it corrected.

=IF(J2>DATEVALUE("5/31/2014"),"GOOD","EXPIRED" J2>DATEVALUE("6/31/2014"),"GOOD","EXPIRING SOON")


See More: EXCEL If Statement Using Dates

Report •

✔ Best Answer
June 27, 2014 at 08:05:00
Fieldman,

Sorry it's taken me a day to get back to you, I've been pretty busy...

I don't know if I understand what you're wanting to do or not, but the only way that I'm aware of to put multiple "IF" statements into one field is to do it the way I demonstrated above. You can put as many as you'd like in there to achieve what you're trying to do.

This is just a shot in the dark, but I've re-read your posts several times now and am wondering if it would work the way you want if you change the formula in A2 to something like this:

=IF(A1>DATEVALUE("5/31/2014"),"GOOD",IF(A1>DATEVALUE("6/31/2014"),IF(A1>DATEVALUE("5/31/2014"),"EXPIRED","EXPIRING SOON"),"EXPIRING SOON"))

I really think you will need to play with the formula above to make it work, but I think something like this is going to be your best bet.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.



#1
June 25, 2014 at 13:16:13
Check out the link below. If this does not answer your question or you have further questions, please let me know!

http://support.microsoft.com/kb/214094

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

#2
June 25, 2014 at 13:22:24
Thank you, I will check it out now

Report •

#3
June 25, 2014 at 13:41:47
It didnt have what i was looking for. I want to make something like a =if statement with it defining whether a date is good expired or almost expired. I have it already where it can say good or expired because that is TRUE or FALSE but I need something like

=IF(CELL>DATEVALUE("DATE"),"GOOD","EXPIRED" OR IF CELL<DATEVALUE('DATE"),"EXPIRING SOON", "GOOD"

if the above makes any sense of what I am trying to explain lol

I want one cell to judge another cell and determine whether it should say GOOD EXPIRED OR EXPIRING SOON


Report •

Related Solutions

#4
June 25, 2014 at 14:34:35
In your IF statement, is "DATE" supposed to be a variable or will it be a specific date that will not change?

Just an idea, if it is supposed to be a variable, just set it equal to a field on your spreadsheet that has a date in it that you can change.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

#5
June 25, 2014 at 14:47:05
Anyway, you would want to try to do something like this (You will probably need to modify this slightly to meet your criteria):

=IF(J2>DATEVALUE("6/14/2014"),IF(J2>DATEVALUE("6/20/2014"),"GOOD","EXPIRING SOON"),"EXPIRED")

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

#6
June 25, 2014 at 15:06:16
The dates are fixed. Now that I see your formula above, I want to have two true and false statements.

Basically saying I want two IF statements adjusting the same cell while creating the results of that cell from the date in another cell.


A1 = 6/14/2014
A2 = =IF(A1>DATEVALUE("5/31/2014"),"GOOD","EXPIRED")

In addition, I want A2 to be manipulated by this IF statement as well:

A2 = =IF(A1>DATEVALUE("6/31/2014"),"GOOD","EXPIRING SOON")

I saw your Law of Logical Argument and say this lol:

Is it possible to have both formulas judging a cell event(A1) and manipulating A2 to say whether A1 is GOOD, EXPIRED, OR EXPIRING SOON

lol

message edited by fieldman


Report •

#7
June 25, 2014 at 18:15:54
How about adding a bit of Color to your life,
take a look at this How-To and see if you can use it:

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

#8
June 27, 2014 at 08:05:00
✔ Best Answer
Fieldman,

Sorry it's taken me a day to get back to you, I've been pretty busy...

I don't know if I understand what you're wanting to do or not, but the only way that I'm aware of to put multiple "IF" statements into one field is to do it the way I demonstrated above. You can put as many as you'd like in there to achieve what you're trying to do.

This is just a shot in the dark, but I've re-read your posts several times now and am wondering if it would work the way you want if you change the formula in A2 to something like this:

=IF(A1>DATEVALUE("5/31/2014"),"GOOD",IF(A1>DATEVALUE("6/31/2014"),IF(A1>DATEVALUE("5/31/2014"),"EXPIRED","EXPIRING SOON"),"EXPIRING SOON"))

I really think you will need to play with the formula above to make it work, but I think something like this is going to be your best bet.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.


Report •

Ask Question