SharePoint List - Count Between Dates with an Exception

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3140418%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESharePoint%20List%20-%20Count%20Between%20Dates%20with%20an%20Exception%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3140418%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20everybody!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20attempting%20to%20create%20a%20SharePoint%20List%20column%20that%20counts%20how%20many%20days%20since%20creation%20(checkout%20date)%2C%20however%20I%20want%20the%20column%20to%26nbsp%3B%3CSTRONG%3Estop%26lt%3B%5C%2FSTRONG%26gt%3B%20calculating%20once%20an%20end%20date%20(return%20date)%20has%20been%20input.%20Basically%20I'm%20using%20this%20functionality%20to%20show%26nbsp%3B%3CEM%3Ehow%20long%26lt%3B%5C%2FEM%26gt%3B%20an%20item%20has%20been%20checked%20out.%26lt%3B%5C%2FP%26gt%3B%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20currently%20using%20this%20formula%20for%20the%20DAYS%20OUT%20column%3A%20%3DTODAY()-Created%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20appreciative%20of%20any%20support.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3140418%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3ELists%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EMicrosoft%20Lists%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ESharePoint%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi everybody!

 

I'm attempting to create a SharePoint List column that counts how many days since creation (checkout date), however I want the column to stop calculating once an end date (return date) has been input. Basically I'm using this functionality to show how long an item has been checked out.

 

I'm currently using this formula for the DAYS OUT column: =TODAY()-Created

 

I'm appreciative of any support.

0 Replies