Formula Looking at 2 Dates

Taylor Riley

Hi!

I'm working to track whether or not the need by date entered on request forms abide by our 7-business day SLA. The goal is to see out of the requests that were not completed by the need by date, how many of those requests were outside of our SLA. I need a formula where, If the [Need By Date] column is at least 7-business days from the [Date Created] column, "Yes" is returned.

Thank you!

Paul Newcome

Try something like this...

=IF(NETWORKDAYS([Date Created]@row, [Need By Date]@row) < 7, "Yes")