+ Reply to Thread
Results 1 to 3 of 3

Date Calculation need for First of the month following 1 month

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Date Calculation need for First of the month following 1 month

    Hello Excel Forum. I'm looking for a formula that will return the correct date given a specified date in another cell. Specifically, the formula needs to return the date that is the First of the month following 1 month from the given date.

    Example: If cell B2 contains the given date, then cell B4 needs a formula that will look at the given date in B2, add 1 month (not days, but literally 1 month, so if the given date is February 1st, the formula will add 1 month from Feb 1st which would be March 1st), and then return the correct date.

    So any given date that has a 1st of the month date (e.g. 1/1, 2/1, 3/1, etc.), the formula should return a date that is exactly 1 month later (i.e. if given date is 2/1, the formula should return a result of 3/1).

    If the given date is any day of the month other than the first day of the month (so days 2-31), then the formula should return a result that is the 1st of the month following (e.g. if given date is 1/2/14, the formula should return a result of 3/1/14).

    Attached is a sample worksheet.

    Many thanks in advance.

    be well

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Date Calculation need for First of the month following 1 month

    Using your posted workbook
    This regular formula returns the 1st day of the month after the first full month of hire
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Re: Date Calculation need for First of the month following 1 month

    Wonderful. Works perfectly. Thank you so much, Ron.

    Be Well!

+ 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. Month to Date Calculation - Driving Me Crazy!
    By Peeekay in forum Excel General
    Replies: 7
    Last Post: 03-30-2012, 03:26 PM
  2. End of month date calculation
    By singerbatfink in forum Excel General
    Replies: 3
    Last Post: 11-23-2011, 07:01 AM
  3. a difficult date and month calculation problem
    By jolinchew in forum Excel General
    Replies: 9
    Last Post: 10-06-2011, 04:58 AM
  4. [SOLVED] Excel month dropdown list to generate day of week and date for selected month
    By aaaaaaaa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2010, 02:45 PM
  5. [SOLVED] Extracting Month from Date and doing a calculation
    By gb in forum Excel General
    Replies: 8
    Last Post: 01-03-2006, 04:10 PM

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