|What is it your doing?|
Your "current" formula looks for Less Than 30 days
while your other looks for Greater Than 90 days
A bit more of an explanation of what it is your trying to accomplish would help.
How do I change this formula to get 30+ and 60+ columns?
=IF(TODAY()-C2>30,H2," ") should get you greater than 30
=IF(TODAY()-C2>60,H2," ") should get you greater than 60
But be aware that the 30 Days is within the 60 days,
so when it's 60 days both will be true.
And Excel questions are best asked in the Office Software forum.
message edited by mmcconaghy