Administration and Executive AssistantTier 920 minadvanced

ISOWEEKNUM at a Year Boundary

Report the correct ISO week number for a log entry made right at the turn of the year.

What you will learn

• Use ISOWEEKNUM to find a date's week number under the international standard
• Explain why WEEKNUM's default numbering and ISOWEEKNUM can disagree right around January 1st
• Recognise which system a specific reporting requirement actually calls for

Excel skills

ISOWEEKNUM · Date Calculations

The task

A log entry was made right at the turn of the year. Report its ISO week number - the international standard used for cross-border reporting - in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free