+ Reply to Thread
Results 1 to 2 of 2

Formula to convert weekly task matrix to week number only

  1. 10-22-2020, 10:58 PM #1
    joeyfmg
    joeyfmg is offline
    Registered User
    Join Date
    10-22-2020
    Location
    Perth
    MS-Off Ver
    2016
    Posts
    1

    Formula to convert weekly task matrix to week number only

    I want to use a formula to re-format the weekly matrix (attached -pic1) to week numbers only (attached - pic2).

    pic1:
    pic1.PNG


    pic2:
    pic2.PNG

    Any help is appreciated.
    Reply With QuoteRegister To Reply
  2. 10-25-2020, 01:29 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,546

    Re: Formula to convert weekly task matrix to week number only

    Hello joeyfmg and Welcome to Excel Forum.
    Please utilize the instructions in the banner at the top of the page to upload the .xlsx workbook from which the snapshots are taken.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating weekly totals with a variable number of items per week
    By Ben466 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2019, 08:34 PM
  2. [SOLVED] displaying calculated week number in correct weekly column
    By nigelog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2015, 05:58 AM
  3. allocate costs into matrix based on week number
    By avdbos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2015, 04:09 PM
  4. [SOLVED] calculate weekly volume based on week number
    By karl8695 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2014, 06:23 AM
  5. formula/macro. How to convert data (weekday, week number, year) to a date?
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2011, 10:34 PM
  6. Macro - copy weekly data to a week number
    By Dennikim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2008, 10:47 AM
  7. How can I convert this number into a week#
    By msbutton27 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-25-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1