Sometimes, the YEAR function returns the correct value, but Excel displays an unexpected year, such as 1900 or 1905. This occurs when the cell containing the YEAR formula is formatted as a Date ...

If you need more flexibility for adding new columns than the ones provided out of the box in Power Query, you can create your own custom column using the Power Query ...

There are three main business cases when you could find Listman.io app helpful for your business: You need to archive SharePoint Lists Items with attachments based on some searching criteria into an ...

Today’s post is written by Michelle Gilbert (former MVP, now Microsoft Teams Technical Specialist) and Melanie Hohertz, MVP Community Superstar! Onboarding is a painful experience at many ...

This post will show how to automatically calculate and update a column in a SharePoint list when an item is created or modified. It’s common practice in SharePoint to use lookup columns to manage ...

Thanks to SharePoint rock star Keith Mayer of BrightPlanIT for helping to find an end-user friendly way to add some fun to a SharePoint team site (and Daniel Cohen-Dumani of Portal Solutions for ...