Hi,

New to the site, thanks for your input!

I am trying to create an approval tracking sheet to display if a file is overdue or awaiting completion at various stages, something along the lines of this...

C4 is the date sent to client (with an expect turnaround of 2 workdays) and D4 is the date returned from client.

I think the error lies in the first statement of when a file is not yet returned (blank cell)

=IF(D4="","waiting for client"),IF(D4>WORKDAY(C4,2),"overdue from client"))

Thanks.