Auto Populate Date Column Per Two Existing Columns

Damon Lloyd

I would like to auto populate a PILOT DUE DATE column with a date that is 10 business days from the PDF APPROVED DATE column, when the COLOR PROOF column contains "PILOT".

I thought i had a moderate grasp of formulas, but i have no idea how to even start this one.

Paul Newcome

Try something like this...

=IF([Color Proof]@row = "PILOT", WORKDAY([PDF APPROVED DATE]@row, 10))

Info on WORKDAY function

Paul Newcome

Try something like this...

=IF([Color Proof]@row = "PILOT", WORKDAY([PDF APPROVED DATE]@row, 10))

Info on WORKDAY function