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

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

tutorial:current_week_number_in_excel [2013/01/17 14:01] (current)
Line 1: Line 1:
 +====== Current week number in excel ======
 +Just a quick tip for excel. To receive current week number use formula
  
 + <​code>​=TRUNC(((TODAY()-DATE(YEAR(TODAY());​1;​0))+6)/​7)</​code>​
 +
 +
 +{{tag>​tip tutorial excel current week number date}}
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