+ Reply to Thread
Results 1 to 5 of 5

Insert first day of the year 7 time then each day 7 times till last day of current year.

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    45

    Question Insert first day of the year 7 time then each day 7 times till last day of current year.

    Hello. I could use some help adjusting this code. It mostly works but it's pretty terrible in terms of efficiency as it just basically copies and pastes dates.

    I need to make it so that when I press a button, the first day of the current year is entered into cell C30 of the current worksheet, it is entered 6 more times below totaling 7 times, then each day for the rest of the year is also entered 7 times including the last day of the year. Ideally it would account for leap years and not add extra days. Rows may be inserted at times because these dates will be in a table so doing that hopefully won't break anything.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,726

    Re: Insert first day of the year 7 time then each day 7 times till last day of current yea

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    45

    Re: Insert first day of the year 7 time then each day 7 times till last day of current yea

    Wow omg ty. It is insane fast and works perfectly.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,726

    Re: Insert first day of the year 7 time then each day 7 times till last day of current yea

    Glad I could assist...Tx for rep...

    I'm wondering if this can be achieved without a loop...Some guys are geniuses with formulas...

  5. #5
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    45

    Re: Insert first day of the year 7 time then each day 7 times till last day of current yea

    Yw. I ALWAYS rep for working solutions. I have no idea. I am not one of those geniuses xD This solution is great though.

+ 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. Find dates in current year and previous year delete rows.
    By kreiner2006 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2019, 05:13 PM
  2. [SOLVED] Dropdown list with formula for months of the current year till date
    By mohanys in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2019, 10:37 PM
  3. [SOLVED] VBA Insert Current Month, Year and subsequent months/year for 15 months
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2014, 03:49 PM
  4. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  5. [SOLVED] Keeping a date as current year, even though formula determines previous year
    By dropanddrive03 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2013, 08:31 PM
  6. Replies: 4
    Last Post: 07-16-2012, 07:02 AM
  7. [SOLVED] Auto insert current month's name and current year
    By Webtekr in forum Word Formatting & General
    Replies: 0
    Last Post: 03-03-2009, 05:20 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