SOLVED

Error message Calculating Formulas in the List app in Microsoft Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-1669614%22%20slang%3D%22en-US%22%3EError%20message%20Calculating%20Formulas%20in%20the%20List%20app%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669614%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20list%20from%20Excel%2C%20and%20I%20am%20trying%20to%20calculate%20the%20date%20difference%20in%20a%20column%2C%20I%20was%20able%20to%20create%20the%20formula%20in%20excel%2C%20however%20when%20I%20created%20the%20list%20in%20Teams%2C%20my%20formula%20no%20longer%20works%2C%20so%20I%20tried%20to%20use%20the%20formula%20from%20Support.office.com%2C%20however%20that%20formula%20doesn't%20work%20as%20well.%26nbsp%3B%20How%20do%20I%20calculate%20the%20date%20difference%3F%26nbsp%3B%20I%20used%20this%20formula%26nbsp%3B%3CSPAN%3E%3DDATEDIF(%5BColumn1%5D%2C%20%5BColumn2%5D%2C%22d%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1669614%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1670674%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20message%20Calculating%20Formulas%20in%20the%20List%20app%20in%20Microsoft%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1670674%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20might%20want%20to%20look%20at%20Calculated%20columns%20and%20reference%20something%20like%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fexamples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fexamples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWhilst%20the%20create%20list%20from%20Excel%20can%20be%20a%20nice%20option%2C%20not%20everything%20is%20guaranteed%20to%20work%20on%20the%20other%20side.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20as%20you%20are%20now%20essentially%20in%20the%20world%20of%20SharePoint%2C%20I%20would%20look%20to%20how%20you%20would%20achieve%20what%20you%20need%20in%20a%20SharePoint%20fashion.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3EHenry%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have created a list from Excel, and I am trying to calculate the date difference in a column, I was able to create the formula in excel, however when I created the list in Teams, my formula no longer works, so I tried to use the formula from Support.office.com, however that formula doesn't work as well.  How do I calculate the date difference?  I used this formula =DATEDIF([Column1], [Column2],"d")

2 Replies
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Solution
Hi,

You might want to look at Calculated columns and reference something like https://support.microsoft.com/en-gb/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b...

Whilst the create list from Excel can be a nice option, not everything is guaranteed to work on the other side.

So as you are now essentially in the world of SharePoint, I would look to how you would achieve what you need in a SharePoint fashion.

Thanks

Henry
Highlighted
I tried the formula from that site and it didn't work.