#Office365Challenge Of course working out averages across columns adds value - why export it to Excel to analyse data when you can do it in SharePoint? Day: 280 of 365, 85 left Tools: Office 365, SharePoint Description: Calculate the Average of numbers SharePoint Audience:... Continue Reading →
#Office365Challenge This formula allows you to calculate the day of the week for the date and returns the full name of the day. Day: 279 of 365, 86 left Tools: Office 365, SharePoint Description: SharePoint Show dates as days of the... Continue Reading →
#Office365Challenge Here's an easy formula to calculate the difference between two columns and display the result as a percentage. Day: 278 of 365, 87 left Tools: Office 365, SharePoint Description: SharePoint Using ABS Function Audience: All I'll admit - I used to... Continue Reading →
#Office365Challenge If you need to calculate the difference between dates (on SharePoint), it's a lot easier than you think. Day: 277 of 365, 88 left Tools: Office 365, SharePoint Description: SharePoint Calculate difference between two dates Audience: All You require two... Continue Reading →
#Office365Challenge Adding days to dates is something I use often to calculate review dates in SharePoint. Let me show you how. Day: 276 of 365, 89 left Tools: Office 365, SharePoint Description: SharePoint Calculated Field Formulas - add days to dates... Continue Reading →