If Function Issue

**elvishcreampie** · 10-12-2011, 10:03 AM

How do I use the IF Function (if this is the right function to use) to do the following: I want to be able to see if a subscription end date is coming to within 2 weeks of today's date and to show "look out for renewal"...?

I have tried this so far:

=IF($A$1(DAY(14)<=$J$8),"Look Out For Renewal", "Not Due Yet") But get #ref...

Please help!

Dee

**NBVC** · 10-12-2011, 10:09 AM

Possibly?

=IF($A$1>=$J$8-14,"Look Out For Renewal", "Not Due Yet")

where J8 has due date and A1 contains the date to check (i.e. =TODAY() )

To add Past Due, you can nest an IF:

=IF($A$1>$J$8,"Past Due,IF($A$1>=$J$8-14,"Look Out For Renewal", "Not Due Yet"))

**elvishcreampie** · 10-12-2011, 10:16 AM

You are an absolute GENIUS!! Thank you so much. I forget sometimes it just easier to make things simple in Excel. Would you say then the DAY function is completely unecessary?

Thank you for Past Due also! That looks like a very useful tool! How'd you get so good at all this?

Dee

**scottylad2** · 10-12-2011, 10:19 AM

If you have a date in A1 say 25/01/2011 then in B1 you have =Day(A1) your result will only be the Day thats within the date, ie 25 it's redundant in what you're looking for.