Date comparison

Hi all,

I'm trying to make Excel compare two dates for me, and then check an additional cell to see if anything has happened afterwards - for example, I have deadlines, but then would like Excel to check if there has also been any feedback given if it's after the date of the deadline.

So, I need the formula to see if todays date is more recent than the deadline, and if so, it then needs to check if there has been feedback - and if not, report a +1 for that particular line.

Does that make sense?

Would this be something I could use Sumproduct for?

Thanks

Assuming the deadline is in A1 and the comment cell is A2:

=IF(AND(TODAY()>A1,A2<>""),"+1","")

The formula you wrote will not address each row separately. You need to have a formula in each row to determine each result:

=IF(AND(TODAY()>'ALL Requests'!AB1, 'ALL Requests'!AC1<>""),"+1","")

Then copy the formula down.

Sorry for the delay, I've been busy with other things....

I wonder if there's a way to use Sumproduct for this? So I can just have one cell that totals everything up? I've not managed to do it myself but thought that something like:

=Sumproduct((ALL Requests'!AB:AB>TODAY())*('ALL Requests'!AC:AC<>""))

Would work - no luck so far though!

I don't think Sumproduct likes entire rows referenced. Try using actual ranges:

=SUMPRODUCT((ALL Requests'!AB1:AB1000<TODAY())*('ALL Requests'!AC1:AC1000<>""))

I don't think Sumproduct likes entire rows referenced. Try using actual ranges:

=SUMPRODUCT((ALL Requests'!AB1:AB1000<TODAY())*('ALL Requests'!AC1:AC1000<>""))