September 2011
Beginner
140 pages
3h 40m
English
The WEEKSINYEAR function returns the number of weeks in the given date. For example:
=WEEKSINYEAR(DATE(2012; 2; 16))
returns 52.
Figure 12-12. Sample result of the WEEKSINYEAR function
You can give WEEKSINYEAR the date in a more natural format:
=WEEKSINYEAR("2/16/2012")
returns 52 again.
Read now
Unlock full access