Forum Discussion
Date Calculations in SharePoint List with conditions
Hello. I am trying to do some complex calculations in SP and don't even know if SP has the capability. In a list, I have a Column [Proposed Presentation Date]. There is also a [Created] date col...
mikehamm35 In your calculated column you just need =[Presentation]-[Created] with the result being a number with 0 decimal places. Then you can format the result with JSON column formatting.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)