YEAR function

Excel » Functions » Date and Time » YEAR function »

How to use the YEAR function

The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]

Calculate date given weekday and week number

This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]