Due Date Exercise

Dear Mates,

Please, I need a formula / function that will help me identify on my document register of which document or documents review status was already in 30 days from the submitted date up to the current date (as per the setting of days in G2 cell, for me to easily toggle or change whatever days needed). "DUE" will be the output for the document in which the review status was "PENDING" or "FOR INFORMATION" with reference to the submitted date to the today date. If possible please include in the formula the cell G2 for me to toggle or change to any date the deadline.

Thanks in advance.

Regards,
PJ

In G4 copied down:

=IF(AND(TODAY()-E4>=$G$2,OR(F4="Pending",F4="For Information")),"DUE","NOT DUE")

does this work
=IF(AND(OR(F4="pending",F4="for information"),E4 < TODAY()-$G$2),"DUE","NOT DUE")

test to see if the review status is Either "pending" or "for information" if it is
then see if the date is older than 30days ago - if it is then due

now you can just change the number in G2 and it will base that for the date before to be due

Originally Posted by AliGW

In G4 copied down:

=IF(AND(TODAY()-E4>=$G$2,OR(F4="Pending",F4="For Information")),"DUE","NOT DUE")

Thanks again Miss Ali. It works great!

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Originally Posted by etaf

does this work
=IF(AND(OR(F4="pending",F4="for information"),E4 < TODAY()-$G$2),"DUE","NOT DUE")

test to see if the review status is Either "pending" or "for information" if it is
then see if the date is older than 30days ago - if it is then due

now you can just change the number in G2 and it will base that for the date before to be due

Thanks also mate! It works great as well.

you are welcome