FinanceTier 912 minadvanced

ISO Week Payroll Cutoff

Determine the correct ISO week number for a payroll cutoff date that falls right at a year boundary.

What you will learn

• Use ISOWEEKNUM instead of WEEKNUM for a payroll cutoff at a year boundary
• Explain why WEEKNUM's default numbering resets to week 1 on January 1st regardless of the weekday
• Recognise when the ISO standard and the default numbering disagree

Excel skills

ISOWEEKNUM · Date and Time Functions

The task

This payroll cutoff date sits right at a year boundary. In B2, calculate its ISO week number - the standard payroll actually runs on, not Excel's default week numbering.

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