+ Reply to Thread
Results 1 to 5 of 5

Dates Duplication

  1. #1
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    71

    Dates Duplication

    Hi

    I need some help developing a date formula. In the attached workbook is a sheet for each month. For each Job, on the JAN sheet, I have entered the date in the Date field.

    I need a formula on the FEB thru DEC sheets, that will take the day part (2nd, 15th, 30th) of the JAN dates and use these for the day in the dates for each Job, in the other months.

    So, on the FEB sheet, the first two dates would be 2/2/15 and 2/15/15. Iím not sure how Excel will handle the last date, but I am thinking the last FEB date would be 2/28 or 29, depending if leap year or not. Otherwise, on MAR (thru DEC) sheets the dates would be 03/2/15, 03/15/15 and 03/30/15, and so on, the same days as in JAN.

    Thanks for all your help.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Dates Duplication

    Maybe this......

    For February
    In B14
    Please Login or Register  to view this content.
    and copy down.


    For March
    In B14
    Please Login or Register  to view this content.
    and copy down.

    and so on....

    Does this help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Dates Duplication

    For Feb sheet

    B14 : 2/2/15
    B15 : B14+13
    B16 :
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-18-2010
    Location
    Layton, UT
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Dates Duplication

    Sktneer, your code worked just right. Thanks so much.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Dates Duplication

    You're welcome. Glad I was able to help.

+ 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. Need help with duplication
    By halo12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2014, 10:57 AM
  2. Duplication
    By Williams in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-19-2006, 09:46 PM
  3. no duplication please
    By asmenut in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2005, 05:05 PM
  4. [SOLVED] Duplication
    By Wonderer in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-09-2005, 11:05 PM
  5. Duplication
    By Coltsfan in forum Excel General
    Replies: 1
    Last Post: 03-14-2005, 04:39 PM

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