Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple-Validations (connected to each other) Data Validation
  • VALUE() of LEFT() Formulas - combined functions
  • New function IFERROR, finally IFERROR
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • CountIf limitation COUNTIF
  • Skills Grid Conditional Formatting
  • IF with AND and IF with OR AND
  • MID + SEARCH to convert cell to rows MID

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

  • VALUE() of LEFT() Formulas - combined functions
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Count how many times letter found Formulas - combined functions
  • IF with AND and IF with OR AND
  • Extract current (Active) workbook name CELL
  • Multiple-Validations (connected to each other) Data Validation

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
  • Progress bar in pure functions CHAR
  • BMI Calculator Basic Math
  • VLookup Lookup and References
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Text-to-Columns, dynamically using formulas IFERROR
  • Count cells with condition – multiple conditions COUNTIFS
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Tally chart in functions Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme