#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 date columns in your library/list (I’ve just used the Created and Modified columns).
Create a calculated column, select the columns and add a minus “-” between the columns:
Here you’ll see the value automatically populated:
You can also calculate the difference in months and even ignore the years:
Yay for formulas!
Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.
May 20, 2019 at 6:36 pm
Hi, I’ve attempted to use your advice for using a formula in the new SharePoint to count the number of days between two dates. I can’t seem to get it to work, do you have any advice?
May 27, 2019 at 5:48 am
Hi. First thing I’ll check is difference between using the comma and semicolon in formulas. That always catches me when copying formulas from posts. https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)
February 28, 2021 at 6:37 pm
Do you have a method or formula to return the average of the calculated column in SharePoint?
May 1, 2021 at 8:42 am
Hi Gloria, you could try this: https://support.microsoft.com/en-us/office/average-function-73cdedbf-5954-492d-a32d-aa9fbc29c5ec