Nested IF fuction help. ? Correct approach

Hi All

Newbie to using Excel beyond a very basic level and would appreciate any help with this. I am creating rules in a consumables log to alert when expiry dates have arrived.

I have been able to achieve this using the following rule:

=IF(DAYS360(A1,TODAY())>=0,"EXPIRED","")

I then use conditional formatting to change the fill and font when "EXPIRED" text appears to make the field stand out.

I would also like to modify the rule to create an alert in the same field when an expiry is approaching (10 days before expiry up to the day before = "Soon to Expire"), followed by the "Expired" comment on the day of expiry.

I have attempted this by nesting additional IF functions without success.

Not sure if I'm taking the right approach here so any help would be greatly appreciated.

=if(Days360(A1,Today())>=0,"EXPIRED",if(Days(360(A1,Today())>=-30,"Soon to Expire",""))

I think.

I'm assuming A1 is your expiry date?

This should do what you want it to...

Please Login or Register  to view this content.

Hi yudlugar. Thanks for your help. I can see the logic here but I get a error with this rule and I can't understand why.

Hi cheeze83.

This works great and I learnt something also. Thanks for your help.

No worries Glad it worked.

For completeness sake, I added an extra bracket between days and 360 accidently.
=if(Days360(A1,Today())>=0,"EXPIRED",if(Days360(A1,Today())>=-10,"Soon to Expire",""))

is what it should have been.