Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » All Tags » Power Tips » UDFs (RSS)

Browse by Tags

  • Calculate the ISO Start of Year date

    Today’s author is Shane Devenshire, who has been an Excel MVP for many years and who regularly contributes to Excel Newsgroups. He has published over 300 articles in different computer magazines, and co-authored numerous books. Excel might be better today because of the many bugs he posted when he was a Beta tester! This post shows you how to use a formula or custom VBA function to calculate the ISO Start of Year date. Here is a formula for calculating the ISO Start of Year date for any legal Excel...

  • Week Numbers in Excel

    Today’s author is, Ron de Bruin, an Excel MVP . You can find more useful tips from Ron and links to Excel add-ins at his website: http://www.rondebruin.nl/ There are four primary week numbering systems in use worldwide. Each system has subtle differences that you should be aware of. Excel can work with any of these systems: 1)  ISO Week number: The International Organization for Standardization (ISO) ISO8601:2000 Standard. All weeks begin on a Monday. Week one starts on Monday of the first week...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.