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
Bookmarks