+ Reply to Thread
Results 1 to 6 of 6

Need to enter date in column 6 mths from date in dif column if the text in dif column is Y

  1. #1
    Registered User
    Join Date
    10-12-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    MAC 2016
    Posts
    4

    Need to enter date in column 6 mths from date in dif column if the text in dif column is Y

    Hi, I need a code that will enter a date in Column I that is 6 months from the date in Column C if you type "Y" in Column H. All dates are in dd/mm/yyyy format. The date result in Column I needs to fall on a workday (M-F non-holidays). E.g., if 6 months from the date in Column G is a Sunday, the date in Column I will be Monday. I have a separate sheet in the same workbook where I've defined the column listing all the holidays as "HOLIDAYS."

    The code will pertain to Sheet1 which is named "OpenCases." NOTE: Sheet1 already has a code that automatically moves the entire row when you enter "Closed" in Column F.

    P.S. - I'm trying to attach a sample workbook but am experiencing issues!

    THANK YOU!!!

  2. #2
    Registered User
    Join Date
    10-12-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    MAC 2016
    Posts
    4

    Re: Need to enter date in column 6 mths from date in dif column if the text in dif column

    Here's the sample workbook. Thanks again!

  3. #3
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Need to enter date in column 6 mths from date in dif column if the text in dif column

    Good afternoon.
    Is that more or less what you need?

  4. #4
    Registered User
    Join Date
    10-12-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    MAC 2016
    Posts
    4

    Re: Need to enter date in column 6 mths from date in dif column if the text in dif column

    Hi, thanks for your response but no that's not what I need. I want it as a code rather than a formula for the H column because new rows with data keep getting added and the other people using this aren't very Excel savy. So I want everything automated. Also, the result in Column H needs to be in dd/mm/yyyy format and the formula you sent me isn't calculating 6 months from the date in Column C. I think it's calculating 7 mths?

  5. #5
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Need to enter date in column 6 mths from date in dif column if the text in dif column

    Hi.
    BUT ARE NOT 180 DAYS, DISCOUNTED ON SUNDAYS?

  6. #6
    Registered User
    Join Date
    10-12-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    MAC 2016
    Posts
    4

    Re: Need to enter date in column 6 mths from date in dif column if the text in dif column

    I need to add 6 months to a date. Not 180 days. It's not the same thing. For example, 1/1/2017 + 6 months = 7/1/2017 but because that's a Saturday, the answer needs to be 7/3/2017. But 1/1/2017 + 180 days = 6/30/2017, and that's incorrect for my purposes.

+ 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. Replies: 7
    Last Post: 08-09-2015, 05:07 PM
  2. [SOLVED] Sum column AB by date range in Column N and text in column X
    By richtree in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2014, 12:04 PM
  3. Replies: 8
    Last Post: 04-29-2014, 02:27 AM
  4. Replies: 4
    Last Post: 04-11-2013, 04:06 AM
  5. Automatically enter date into a column and make that column read only
    By Mr Davo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2012, 07:58 PM
  6. Replies: 15
    Last Post: 02-06-2012, 04:25 AM
  7. Enter date in column L if value is entered in column B
    By Mikus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2005, 06:05 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