Question

Locked

IF Statement in excel

By michaele.grabowski ·
Hi,
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?

Thanks!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Creating A ?Megaformula?

by Peconet Tietokoneet In reply to IF Statement in excel

Hope this helps, go here:

http://tinyurl.com/b62bco

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.

-C.W.
http://www.oneclickcommissions.com/excel-statement.html

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums