This topic has been archived. It cannot be replied.
-
枫下家园 / 电脑用户 / 求救:工作中需要将一些日期转换成星期,比如1月31日是一年中的第5个星期,即DATE--
>WEEK,在EXCEL中该用什么公式,试过EXCEL中的DAYS360但是每个月都是按30天算
的,不准确。请支招,谢谢!
-bondexpert(神勇无敌小白鼠);
2004-3-8
(#1635840@0)
-
小白鼠Suppose you have date in cell "A1" use "=TRUNC(((A1-DATE(YEAR(A1),1,0))+6)/7)"
-charleslike(Unionville-愚人);
2004-3-8
(#1635887@0)
-
好像不行,29天和31天的问题处理了吗?+6是什么意思?谢谢!
-bondexpert(神勇无敌小白鼠);
2004-3-8
(#1635967@0)
-
I tested a few dates, it looks fine. Can you give me an example which day does not work for you so I can examine this formula?
-charleslike(Unionville-愚人);
2004-3-8
(#1636334@0)
-
search weeknum() function in help
-company(company);
2004-3-8
(#1635978@0)
-
Sorry, nothing is coming out except "weekday" function, but it's not what I'm looking for. Thanks! up up!!
-bondexpert(神勇无敌小白鼠);
2004-3-8
(#1636211@0)
-
That's really what you are looking for, but you need to make it available first. That's why I ask you to look into the help.
-company(company);
2004-3-8
(#1636228@0)
-
you need to install Add-ins from the tool menu and add in Analysis Toolpak, after that you can see th weeknum() function
-schen(糊涂阿福);
2004-3-8
(#1636343@0)
-
Got it, thank you guys!
-bondexpert(神勇无敌小白鼠);
2004-3-9
(#1636957@0)