You are here: Hello » Tutorials » Current week number in excel

Current week number in excel

Just a quick tip for excel. To receive current week number use formula

=TRUNC(((TODAY()-DATE(YEAR(TODAY());1;0))+6)/7)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported

Hey.lt - Nemokamas lankytojų skaitliukas XHTML