Software·43,781 discussions

Connecting date in IF statement in Excel

Locked

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!

Topic

An OR function does it

In reply to Connecting date in IF statement in Excel

=IF(OR(D2-TODAY()<30,E2-TODAY()<30),"Due within 30","Not due")

[Author]

Replies