+ Reply to Thread
Results 1 to 4 of 4

Excel months,

  1. #1
    Forum Contributor
    Join Date
    01-24-2013
    Location
    NY,NY
    MS-Off Ver
    Excel 2010
    Posts
    196

    Excel months,

    I would like to know which months I would need to change my water filters.
    So for example:

    I purchased my water filter on 01/01/18 and the directions say, "replace water filter on a quarterly basis." So now I know I have to change my water filter every 3 months.
    How can I have excel show which months they are, or how can I have excel produce the results.

    Jan, April, July,October, Jan

    Thank you,

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,797

    Re: Excel months,

    Try

    Please Login or Register  to view this content.
    Martin

    If my solution has saved you time and/or money, please consider donating to Cancer Research UK or your local equivalent.

    https://www.cancerresearchuk.org/

  3. #3
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,520

    Re: Excel months,

    Or, if your original date (1/1/2018) is in A1, put this in B1 and drag right =EDATE(A1,3)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  4. #4
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,520

    Re: Excel months,

    My post #3 is for each date set in its own cell, if you like Martin's approach in post #2 with it all in one cell then this would be an alternative...
    =TEXT(EDATE(A1,3),"mmm")&" "&TEXT(EDATE(A1,6),"mmm")&" "&TEXT(EDATE(A1,9),"mmm")&" "&TEXT(EDATE(A1,12),"mmm")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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