rjwebgraphix
Well-known Member
- Joined
- May 25, 2010
- Messages
- 590
It's been a while since I've EXCELled at anything, and just trying to do something which should be simple, but it's like rewinding my brain a decade trying to figure this out.
I have a simple formula that will tell me if a date is within 3 months or not.
=IF(AND(E3>=TODAY(),E3<=EDATE(TODAY(),3)),"DUE","not due or PAST DUE")
This works for that purpose, but I need another condition added to it. If within 3 months of today including today it's Due, If it's older than today's date It's Past due, otherwise, don't care about it.
Could someone help me in adding the past due and don't care conditions. Don't care can be "".
Thanks.
I have a simple formula that will tell me if a date is within 3 months or not.
=IF(AND(E3>=TODAY(),E3<=EDATE(TODAY(),3)),"DUE","not due or PAST DUE")
This works for that purpose, but I need another condition added to it. If within 3 months of today including today it's Due, If it's older than today's date It's Past due, otherwise, don't care about it.
Could someone help me in adding the past due and don't care conditions. Don't care can be "".
Thanks.