IF Statement in excel

By michaele.grabowski ·
I have two columns in excel which contain various dates in the future for deliverable due dates. I would like to create an IF statement in excel which will pull up the deliverables that are hitting in the next 30 dates in either of columns. I can create an IF statement for the next 30 days for one column, but I do not know how to create a formula that combines both columns. Any advice?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Creating A ?Megaformula?

by Peconet Tietokoneet In reply to IF Statement in excel
Collapse -

Possible Formulas

by JNirvaha In reply to IF Statement in excel

Try using ARRAY with two IF's in the middle. To reference the +30 days you can use =TODAY()+30 . Maybe even put this in its own cell and refer to this externally.

Hope this is a start.


Related Discussions

Related Forums