+ Reply to Thread
Results 1 to 7 of 7

Date extensions

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    Hibbing, MN
    MS-Off Ver
    MS Office 07
    Posts
    22

    Date extensions

    So I have attached a spreadsheet. I have a formula in the effective date. Now what I would like to have happen is to have based on the date populate the month that we would need to meet with them. In example attached because they have a 4/1/2017 effective date we would meet with them in March. is this even possible? I need to have the months broken out for ease I think until you can think of a better way.

    I appreciate for any and all of you who help out here!!! I know what I want to do but the figuring out how to do it is beyond me.

    Kat
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Date extensions

    Hi,

    Put proper date numbers in E1:P1 - format as required.

    Then in E2 copied across and down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Date extensions

    Put this in E2 and drag across to all the months:

    =IF(TEXT($D2-1,"mmmm")=LEFT(E$1,FIND(" ",E$1)-1),"X","")

    Hope this helps!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Date extensions

    You can put this formula in cell E2:

    =IF($D2="","",IF(DATEVALUE(1&LEFT(E$1,FIND(" ",E$1))&YEAR($D2))=EDATE($D2,-1),"x",""))

    then copy across and down as required.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    01-11-2017
    Location
    Hibbing, MN
    MS-Off Ver
    MS Office 07
    Posts
    22

    Re: Date extensions

    Thanks worked thanks

    Kat

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Date extensions

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Date extensions

    Thanks for the rep, Kat, and for going back to your previous thread and wrapping that one up.

    Pete

+ 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] File Extensions
    By 1vision in forum Excel General
    Replies: 4
    Last Post: 05-19-2014, 04:35 PM
  2. getting files' extensions?
    By ahartman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2008, 12:50 PM
  3. extensions on every filename
    By njbabay in forum Excel General
    Replies: 5
    Last Post: 11-06-2007, 09:48 PM
  4. [SOLVED] file extensions
    By dottiea in forum Excel General
    Replies: 1
    Last Post: 07-27-2006, 11:20 AM
  5. File Extensions
    By Robin Clay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2006, 11:55 PM
  6. Extensions
    By Royshh in forum Excel General
    Replies: 0
    Last Post: 04-25-2005, 12:13 PM
  7. XML file extensions
    By Rowan in forum Excel General
    Replies: 2
    Last Post: 04-22-2005, 03:06 AM

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