+ Reply to Thread
Results 1 to 5 of 5

creating formula that displays the same date for each additional month

  1. #1
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    142

    creating formula that displays the same date for each additional month

    Need help creating formula that displays the same date for each additional month, like:

    7/20/2017
    8/20/2017
    9/20/2017

    The only way I know how to do this is by taking the 1st cell and adding 30 days but obviously, that didn't work very well.

    Thanks for looking at this.

    Bruce

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: creating formula that displays the same date for each additional month

    Hi
    try

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    142

    Re: creating formula that displays the same date for each additional month

    Perfect, worked great

  4. #4
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: creating formula that displays the same date for each additional month

    another formula for your information
    =EDATE(A1,1)
    This will add one month to A1

    =EDATE(A1,2)
    This will add 2 months to A1 and so on

  5. #5
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    Posts
    142

    Re: creating formula that displays the same date for each additional month

    I'll try that one too.

    Thanks.

+ 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] Userform displays saved recorded dates with month and date in reverse order
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2015, 08:34 AM
  2. Replies: 6
    Last Post: 07-13-2015, 12:35 PM
  3. Replies: 4
    Last Post: 06-27-2015, 01:51 AM
  4. [SOLVED] Need a Formula that displays the relevent date after checking the day entered as text
    By john dalton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2014, 04:56 AM
  5. [SOLVED] Help creating a formula that using If,index, match and displays only the newest dates...
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2013, 02:28 PM
  6. [SOLVED] Formula that displays the oldest date and earliest date
    By mrcois in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-20-2012, 12:22 AM
  7. Cell displays last date of next month.
    By markswan20 in forum Excel General
    Replies: 6
    Last Post: 12-10-2009, 08:16 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