+ Reply to Thread
Results 1 to 10 of 10

Display the first of the following month based on a date in previous cells

  1. #1
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Red face Display the first of the following month based on a date in previous cells

    I would like to have the following month appear in a cell based on the previous cell.

    So if one cell is 02/26/19, the next cell would be 03/01/19.

    Thanks for any help with the formula.

    Nick

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Display the first of the following month based on a date in previous cells

    why would the next cell be 3/1 if the other cell is 2/26 (what happens to 2/27 and 2/28 for example)? Someone will need to know what logic you are using in order to create a formula for it.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Re: Display the first of the following month based on a date in previous cells

    It’s actually just for helper cells, one would be a start date and I would have the remaining be the first of each month.

    Thanks,
    Nick

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Display the first of the following month based on a date in previous cells

    so, whatever the date is in the one cell, you want the adjacent cell (next column over) to have the first date of the next month, is that correct? So for example if the date was 2/15/19 you'd want the next one to be 3/1/19?

  5. #5
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Re: Display the first of the following month based on a date in previous cells

    I got this to work.

    =EOMONTH(A1,1)+1

  6. #6
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Re: Display the first of the following month based on a date in previous cells

    Nope, spoke too soon, that skips a month.

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Display the first of the following month based on a date in previous cells

    ha ha, that is what I was going to recommend if post #4 was correct.
    Glad you got it yourself.

    Oops, make it this way...
    =EOMONTH(A1,0)+1
    and you're there.

  8. #8
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Re: Display the first of the following month based on a date in previous cells

    Yes that is correct.

  9. #9
    Forum Contributor
    Join Date
    07-10-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    244

    Re: Display the first of the following month based on a date in previous cells

    Thanks, Sambo kid!

  10. #10
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Display the first of the following month based on a date in previous cells

    you're welcome, glad I could help!

+ 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: 2
    Last Post: 09-21-2017, 02:00 PM
  2. [SOLVED] Showing a decline in Date/Month based on previous cell
    By avidcat in forum Excel General
    Replies: 5
    Last Post: 01-25-2014, 09:47 PM
  3. Display Date Range of previous month
    By Oscar68 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2012, 12:39 PM
  4. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  5. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  6. Display end of month date for previous month
    By erikwvb in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 01:22 PM
  7. Formula to display the last day of the previous month
    By avidcat in forum Excel General
    Replies: 6
    Last Post: 01-22-2010, 10:01 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