Formula help please, IF function with GREATER THAN TODAY minus 30 days

[Morrowend]

I'm currently using a formula to act as a prompt to contact people who are overdue or not current members and want to change it to prompt about a month before their membership runs out.

I know I could add an extra column for the due date and use DATEDIF but I'd rather keep fewer columns on the spreadsheet (my dad has to be able to use it and the more columns the more likely it is to not be filled in correctly) so I wondered if there is a way to change my current formula from giving a prompt required message only after the renewal date to the renewal date less 30 days.

My current formulas is this:

=IF(ISBLANK(F15),"Required",IF(F15>TODAY(),"","Required"))

Anyone have any ideas?

 

[Rorylfc]

Try This

[/COLOR]=IF(ISBLANK(F15),"Required",IF((F15-TODAY())<30,"Required",""))

 

[Morrowend]

Thank you very much, that works perfectly, and it's fairly obvious now I've seen it written out