Nested IF statements

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I want to write a nested IF statement in Excel that will look in a cell at a date and if that date is passed then in the cell next to it write "out of date" or if the date is within 30 days then it will say "Renewal date soon".

I can write an IF Statement that does the first bit about being out of day but I can not add the second part properly.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Sorry its taken a while, i only saw your topic today.

heres the if statement you want

=IF(A1<TODAY(),"Out of Date",IF(A1<(TODAY()+30),"Renewal Date Soon","Everythings OK"))

it assumes the date is in A1 so you need to change BOTH occurences of that to make it fit to your sheet

That was a bit if a tricky one, I've not dont nested IF's in a long time, but its fin to play again, lol.

Hope this is still usefull and youve not already found out

 

Thanks for that I had'nt found the answer (was about to give up).