I have this for my "current" column =IF(TODAY()-C2<30,H2," ")

and this for my 90+ column =IF(TODAY()-C2>90,H2," ")

How do I change this formula to get 30+ and 60+ columns?

What is it your doing? Your "current" formula looks for

Less Than 30 days

while your other looks forGreater Than 90 daysA 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 60But 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.

MIKE

message edited by mmcconaghy

I found my answer Mike. Thanks for responding.

Ask Your Question

Weekly Poll