Help with Dates and IF Statements

[chrysti]

=IF(E10="","",(DATE(YEAR(E10),MONTH(E10)+13,1)))
I am using this formula to add 13 months (regardless of the date) to a date
so even if the date is 12/31/2005 I want it to state 1/1/2007 which the formula does from what I can see. I also want it to look at a cell which contains todays date with the =today() formula and if today is greater than the date I am looking than A otherwise B =IF(VALUE($I$10)>VALUE(I2),"A","B") I tried using this formula, but I can't get it to work the way I want, I am really only concerned with the Month and the Year not the Date, but that had to be in the formula to return a date, so I have everything pointing to the first day of the month. Please someone help, I just want it to read if it is bigger than todays date or not. I made them values because I couldn't think of any other way to try and make it work.

Thanks in advanace for all your help!
Chrysti

[Carim]

Hi,

Please Login or Register  to view this content.

HTH
Carim

[chrysti]

you posted an answer to my quesiton which worked wonderfully, but now I have decided that I want to add to it.

I have this formula
=IF(I14="","",IF(F14>TODAY(),IF(I14<TODAY(),"A","B "),"CLOSED"))
Basically I have a date in col I (the open date) that I want to reference if the account is open or closed, and in col F is the close date, so I want it to look at col F, but F reads off of another page so that is not truly a value it is a vlookup, can this be done? I am hoping so. Please let me know if there is a solution to this.

Thanks so much for your help!
Chrysti

[Carim]

Hi again,

Please Login or Register  to view this content.

HTH
Carim

[Carim]

OOps read your post too quickly ...

with F14 from another worksheet ...

Please Login or Register  to view this content.

HTH
Carim

[chrysti]

I am trying to get the formula to give me back a value to code with
=IF(P10=0,IF(H10<TODAY(),"A",IF(H10>TODAY(),"B",IF(P10<TODAY(),"C"))))
in col H I am putting the date that an account will open or was opened, so I want it to say "A" if it is already open and "B" if the date has not passed yet to show that it is pending, and I have a closing account date in col P which I want to reflect "C" only if there is a date that has passed in that column otherwise I want it to reflect "A" until the date in col P is equal to today()

thank you so much, everything else has been so helpful Carim!!!

Thanks to anyone who can help!
Chrysti