Solved Excel If Then with dates & amounts to create aging

September 7, 2016 at 09:42:37
Specs: Windows 64
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?

See More: Excel If Then with dates & amounts to create aging

Reply ↓  Report •


#1
September 7, 2016 at 10:40:48
✔ Best Answer
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.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#2
September 7, 2016 at 13:33:47
I found my answer Mike. Thanks for responding.

Reply ↓  Report •

Related Solutions


Ask Question