Formulae Correction Required - Date

[jon112211]

Hi,

I am using this formulae IF(F5<=TODAY()+30,F5-TODAY()&" days left!","")

but for date
i) 06/02/2015 result is : Blank Bcoz it exceeds 30 days limit
ii) 04/02/2015 result is : 29 days left!
iii) 04/02/2014 result is : -336 days left!

But i want the result blank if more than -30 days left! .... example iii) must come blank bcoz its more than -30 days left!

so result should be blank in both i) & iii)

Thanks
Jon

[Jonmo1]

Try changing the = to <=

Also, that's a 60 day difference in your formula
You subtracted 30 from E11, but Added 30 to Today

So a difference of 60 or less would trigger the text, blank for more than 60.


You probably should remove either the -30 from E11, or the +30 on Today.

[jon112211]

oops...sorry dear.. i corrected it... still not getting the result i wanted...

[Jonmo1]

What formula do you have now?
What date is actually in F5
What results do you expect with what dates in F5 ?

Maybe post a sample book
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[samba_ravi]

=IF(AND(F5>=TODAY()-30,F5<=TODAY()+30),F5-TODAY()&" days left!","")
TRY THIS

[jon112211]

check attachment

[jon112211]

Thanks nflsales & Jonmo1
its done