Skip to main content
Nintex Community Menu Bar

O365: Calculated column needs to calculate the difference between two dates but exclude Sundays

  • December 6, 2021
  • 0 replies
  • 27 views
  • Translate

Forum|alt.badge.img+2

I am currently using SharePoint O365 custom list with a New Responsive Form. I am looking for a way to utilize my calculated column to calculate the difference between two dates, but to exclude Sundays from that calculation (as these are considered exception dates). I also need to be able to reflect the difference on my form as well.

Column Calculation so far: =[Completion Date]-[Received Date]

Form Variable Formula so far:  dateDiff("totaldays",[Form].[Received Date],[Form].[Completion Date])

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings