All Articles

Browse all posts across all categories

SharePoint: YEAR function

SharePoint: YEAR function

Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.

The site is 7 years today

The site is 7 years today

Seven years of the site. The newsletter is live, new reference areas launched, and old articles updated.

Excel: Averageif Function

Excel: Averageif Function

Averages the values that meet one condition. Returns #DIV/0! when nothing qualifies.