WeekNum

Description of formula:
Calculates week number in year, returns number from 1 to 53.
Syntax:
weeknum(date, [mode])
Parameters:
date
(type: Date) date to calculate week number form.
mode
(type: Number) 1 - week begins with sunday, 2 - week begins with monday, 1 is default value.
Returned type:
Number
Examples:
=weeknum(A1)
=weeknum(A1, 1)
=weeknum(Date(2000,1,1), 2)
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk