+ Reply to Thread
Results 1 to 2 of 2

Return Value to Month-Year and Week Number

  1. #1
    Forum Contributor
    Join Date
    05-13-2009
    Location
    Manila philippines
    MS-Off Ver
    Excel 2010
    Posts
    113

    Return Value to Month-Year and Week Number

    Hi,

    I have table containing list of dates in Column A. I would like the value in Column B to be "mmm-yyyy". For Column C, I would like to return the value to week number.

    Week No. Day From Day To
    Week 1 1 7
    Week 2 8 14
    Week 3 15 21
    Week 4 22 31

    How can I automate this using VBA. Please note the I will be updating the column A from time to time. Hence, I am hoping that the code will not be a specific range only. The code will only stop on the last row of the table.

    thanks
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Return Value to Month-Year and Week Number

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do return days,week no,month and year in between two dates
    By silambarasan.J in forum Excel General
    Replies: 5
    Last Post: 10-26-2016, 04:29 AM
  2. Return averages based on day, week, month and year, from dates in column.
    By koalamotorsport in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2016, 11:11 PM
  3. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  4. Replies: 28
    Last Post: 07-17-2015, 07:32 AM
  5. [SOLVED] Trying to return the week number of dates in a fiscal year
    By NedFlanders in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2013, 09:16 PM
  6. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  7. [SOLVED] how to return a day(number) by selecting month and year from data list
    By lizsantiago07 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-24-2012, 02:43 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1