View Full Version : Solved: 52 wks or 53 wks in Year
Hi,
how do i know if the year has 52 wks or 53 wks?? (in formula)..
Thanks..
Bob Phillips
02-13-2007, 10:00 AM
=weeknum(DATE(YEAR(TODAY()),12,31))
=weeknum(DATE(YEAR(TODAY()),12,31))
when i input the formula it display #NAME?
is that a UDF you made or does the version of office affects?
i'm using Office 2k
Thanks..
Bob Phillips
02-13-2007, 10:27 AM
No, it is an Analysis Toolpak function, so you need to install that.
No, it is an Analysis Toolpak function, so you need to install that.
Year 2000 has only 52 weeks but your formula display 53.. is there any other formula rather than using the analysis toolpak function??
Thanks..
Bob Phillips
02-13-2007, 12:12 PM
It depends upon your definition of a week. MS thinks it has 53.
What is your definition?
Brandtrock
02-13-2007, 04:44 PM
Here's what Chip Pearson (http://www.cpearson.com/excel/weeknum.htm) has to say about this.
Regards,
Thanks Brandtrock & XLD..
i use Ron de Bruin week calendar to determine if the year has 52 or 53 weeks..
http://www.rondebruin.nl/weeknumber.htm
Thanks.. :thumb
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.