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%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
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")

4 Replies
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
I tried the formula from that site and it didn't work.
Hi,
I'm having the same issue, though I have started from a blank list. I have also copied the formula and adjusted from the 'Issues' template.
After saving the formula, when I return it has stripped a set of brackets out.
I enter and save =DATEDIF([Deadline],[Reqd By],"d")
When I go to look it says =DATEDIF(Deadline,[Reqd By],"d")
I swapped the columns around and it still took them off 'Deadline.'
But in fact this is the second try as I was working with a different column and created 'Deadline' fresh just to test.
All are set as Date type. It doesn't matter if I type the column or use the 'Add to formula' list.
Any ideas please?
Sorted.
The brackets are only required with spaces in the name.
My errors were because I had the later date first, (thinking of subtractions) and it gives an error if the difference is negative.
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE