Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Worksheet name, dynamically using formula CELL
  • Progress bar in pure functions CHAR
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Blank (isempty) VS “” (null string) Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • When Excel functions are not enough Excel User tips
  • CONVERT function CONVERT
  • Excel Functions = XL f(x)s XLfxs

Week number to Month number

Posted on May 11, 2015 By ANmar No Comments on Week number to Month number

Now we need to convert week number to month number

This is exactly the same as week number to date (reverse weeknum)

So, when the week number is in A5, then formula below will get you the month number

=IF(A5<2,MONTH(DATE(YEAR(TODAY()),1,1)),MONTH(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+((A5-1)*7)+1))

 

Enjoy

DATE, Date and Time, Formulas - combined functions, IF, Logical, MONTH, TODAY, WEEKDAY, YEAR

Post navigation

Previous Post: Why I ran from =INDIRECT() function
Next Post: Extract current (Active) workbook name

Related Posts

  • DayName Date and Time
  • Progress bar in pure functions CHAR
  • Get monthly total from table with dates DATE
  • Schedule column Basic Math
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Excel Limits Excel User tips
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Excel @ before function names in formulas Excel User tips
  • Week number to Sunday date – Weeknum reverse DATE
  • Walking Columns ActiveX controls
  • Min Max vehicle Formulas - combined functions
  • MATCH fumction, just a simple search Lookup and References
  • When Excel tells you to go get some life Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme