Hi everyone please help me on below question:
Column A1: Sent Date
Column B1: Due Date
Column C1: Respond Date
Column D1: Delay (days)
And I want to know how many day have been delayed since I sent out the document base on all these strings.
Example:
A1: 01-Aug-2018
B1: 04-Aug-2018
C1: 08-Aug-2018
So it will count as 4 days delay in column D1 base on the respond date.
And the reason I ask is that when column C1 (respond date) is blank the D1 column will show error or like this 43322, so how can we still get the delay date base on Due Date compare to Today?
Bookmarks