Hello Everyone and forgive if this question has been answered in a previous Post.
Quick background. I created a StartDate using the Date field. Then I created a second column to enter the number of days that the project is expected to be completed. This field is a ‘Number’ field called Duration. Then I created a third field called EndDate which is a formula field where it calculates the number of days assigned to the project with the Start Date to acquire the End Date value. The formula is
DATEADD(StartDate, Number, ‘day’)
First question, is there a way to exclude ‘weekends’ so number of actual days would be business days?
Second challenge - Using the EndDate information, if the project goes past the EndDate by more than 2 business days, I would like that to be populated in a PastDue field where it would state: ‘Past Due by 2 Days’. I would think this has to be tied into using the Computer Clock where it compares the value in the EndDate to the Computer Clock Date.
This is my main question, how can i create a formula field that identifies when a project exceeds the End Date? I would assume it has to be tied to the Computer’s Clock to determine that???