Results 1 to 7 of 7

Updating week number, start date of the week, and year from a column date that's populated

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-30-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Office 365
    Posts
    111

    Updating week number, start date of the week, and year from a column date that's populated

    Good Day,

    I hope this question finds you well.

    I have a sheet with some columns that needs to be populated by people in my team. Once a person changes a value in any cells for columns A, E, F, G, H it should populate the updated date and username automatically (this seems to work but not always for some reason).

    From this updated date in Column I, I would like the year, week number, and the date for that particular week (starting on a Monday) to be populated each time. With that said, once this update occurs based on the original date value in column I, it should not change the values in Column I or J. I hope this makes sense.

    I have read a few article on forums, but can not find something that works for me as I am not an vba expert.

    Basically column I and J is populated once anything changes in certain columns and then column I (green) is used to populate the yellow columns without changing the exiting column I and J again.

    I have even tried the more basic WEEKNUM, but then nothing works column I and J. I would rather have everything running from vba to be automatic without dragging or adjusting formulas in sheets when data row entries increases over time.

    Attached is a example file.

    I thank you in advance.

    Kind Regards,

    Ray
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merge entire rows with same date based on column O and put week number of the year
    By fabian_76 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2017, 11:09 AM
  2. Replies: 5
    Last Post: 04-11-2017, 09:23 AM
  3. Year and Week number but I need to convert to the date of that weeks start
    By darrenj1471 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-07-2017, 09:57 AM
  4. [SOLVED] Get the date of saturday in a week from a week number / year
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2015, 06:56 PM
  5. [SOLVED] Determine Week Start Date From Year And Number
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-23-2013, 07:51 AM
  6. week start date and end date based on week number
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 12:39 PM
  7. Replies: 1
    Last Post: 08-23-2005, 11:42 AM

Tags for this Thread

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