Count + IF Statement?
I would like to count the days from the 'Date' to the 'Date of Completion' once entered and have the counted days in the 'Turn Around Days' column when the status column is clicked 'Complete'
Something like IF Status = complete and the Date is < or = Date of Completion then Turn Around Days are 6 (in this case)
A million dollars for the correct answer as I have no hair left.
Thank you wizards!
Help Article Resources
Check out the Formula Handbook template!