Bukys.eu - Personal Technology and Programming Blog
Bukys.eu - Personal Technology and Programming Blog
  • About Me
  • Blog
  • Projects
  • Tutorials
  • Components Library

  1. You are here
  2. Home
  3. Tutorials
  4. Current week number in excel

tip tutorial excel current week number datetutorial:current_week_number_in_excel

  • Show pagesource
  • Old revisions
  • Backlinks
  • Back to top
  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Pinterest
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
    • Teams
  • Recent Changes
  • Send via e-Mail
  • Print
  • Permalink

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)
tip, tutorial, excel, current, week, number, date
  • tutorial/current_week_number_in_excel.txt
  • Last modified: 2021/04/03 21:00
  • by Ignas
Sidebar

Have something to say? Drop me a message

Bukys.eu - Personal Technology and Programming Blog

Bukys.eu - Personal Technology and Programming Blog


cc by sa

Except where otherwise noted, content on this wiki is licensed under the following license:
CC Attribution-Share Alike 4.0 International

  • Bootstrap template for DokuWiki
  • Powered by PHP
  • Valid HTML5
  • Valid CSS
  • Driven by DokuWiki