I’ve been fortunate these past 2.5 years to work with some incredible colleagues at University of Kansas Libraries. I worked as SharePoint Business Analyst for the libraries (150 staff in 7 branches including an Annex), working to identify solutions using Office 365 to improve communication, collaboration and business processes. I worked to drive adoption and awareness of Office 365 apps and loved everything I was fortunate to be able to do in my time there.
Note: I previously shared how to do this in SharePoint Designer. The following method utilizing Flow is better, and does not use loops/pauses.
It’s well-known that SharePoint calculated columns don’t permit [Today] to be used as a formula for a calculated date column. And the “default to today’s date” setting only works upon creation, and doesn’t update daily. But we can create a standard date column and have Microsoft Flow automatically update it daily for us, therefore allowing us to effortlessly perform calculations against today’s date such as:
- Age =(TodayDate-Birthday)/365
- Years of Service =(TodayDate-StartDate)/365
- Days Past Due =(TodayDate-DueDate)
- Weeks until summer break =(SummerStart-TodayDate)/7
Here’s how to create your own, always accurate/updated, today column (see bottom of post for video):